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.
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.
External data falls into two categories: indexed sequential access method (ISAM) and Open Database Connectivity (ODBC).
The weird issue is that, if I check a linked table from the application, the data is stale.
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.
Oddly enough, I can update linked tables via SQL statements from the app.
DAT401 Presented at Tech-Ed 97 Introduction Data Access Choices External Data Sources Network Access Requirements Performance Guidelines Case Sensitivity Unsupported Objects and Methods Programming Considerations Planning for Portability External Data Access Fundamentals The Microsoft Access database is extremely flexible in its ability to transparently handle data from a variety of sources.