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

Chapter 20. Client/Server Techniques > Working with Linked Tables

Working with Linked Tables

The easiest method of accessing data on the server is to link to the external tables. These linked tables act almost exactly like native Access tables. When you link to remote tables, Access analyzes the fields and indexes contained in the tables so that it can achieve optimal performance. It is important to relink the tables if the structures of the remote tables change. This section discusses how you can link to remote tables through the user interface and by using code.

Linking to External Tables via the User Interface

To link to a remote table through the user interface, right-click on the Tables tab of 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 20.11 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 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. These data sources are available to just one user and just one machine.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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