Access updating using linked tables
When the Show Table window appears, select the tables that you wish to use in the query and click on the Add button.
You can select multiple tables by holding down the Update Query from the popup menu.
For specific recommendations for the data source you intend to access, see the section for that data source later in this paper.
In addition, if a search is made across more than one data source type, the case sensitivity depends on the collating sequences of the databases involved.
These include Microsoft® Fox Pro® database management system, Paradox®, Microsoft Access, and others.
There are two methods of handling the connection to the external data.
Performance will be optimal if you link tables instead of directly opening them, and retrieve and view only the data you need (for example, use restrictive queries to limit results, and don't page up and down unnecessarily).It makes sense to use this approach as an alternative to importing if the external data you want to access is also being updated by software other than Microsoft Access.Even if all data resides in Microsoft Access format you might find it advantageous to link to external data.Because the connection information in this case is not stored with a table definition, there is no link between the external table and a Microsoft Access database, and an icon for the table will not appear in the Database window.In many cases, linking is the faster method for accessing external data, especially when the data is located in an ODBC database.
Although you can use external tables just as you use regular Microsoft Access tables, it's important to keep in mind that they're not actually in your Microsoft Access database.