O'Reilly logo

Alison Balter's Mastering Access 2002 Enterprise Development by Alison Balter

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Working with Linked Tables

Several options are available when working with linked tables. These options are not mutually exclusive; they are generally used in combination within an application. This section covers linking to tables using the user interface and using VBA code. It also talks about linking to views rather than tables.

Linking to External Tables via the User Interface

To link to a remote table through the user interface, right-click within the Database window and then select Link Tables. From the Files of Type drop-down list, select ODBC Databases. The Select Data Source dialog box shown in Figure 11.1 appears. This dialog box has two tabs: File Data Source and Machine Data Source. You use the File Data Source tab to select from ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required