• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 11. Developing an MDB Client/Ser... > Working with Linked Tables

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 the file data source names (DSNs) that have been defined. These are the data sources available to all users on all machines. You use the Machine Data Source tab to select from the user and system data sources you have defined. User data sources are for a particular user on a particular machine, whereas system data sources are for any user on that particular machine.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint