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 ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
