It even has its own icon in the Database window, along with the other tables in the database.
As a result, each time you view data in an external table, Microsoft Access has to retrieve records from another file.
This can take time, especially if the external table is in an ODBC database.
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.
External data falls into two categories: indexed sequential access method (ISAM) and Open Database Connectivity (ODBC).
If you're using external data in an ODBC database and you are unable to link the data, keep in mind that performance when using the data will be significantly slower.
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.There are two methods of handling the connection to the external data.You can link the tables either by using the user interface or from Microsoft Access Basic.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).For specific recommendations for the data source you intend to access, see the section for that data source later in this paper.I have an Access database with a table with a unique key and price field among other fields.