Updating ms access database c Sexcamp
It is also possible to open external databases directly from Microsoft Access Basic.
When a table from another database is linked it behaves just like a native, local table.
This paper provides general information about accessing external data, and then provides specific instructions for each of the supported external data sources.
Microsoft Access Basic provides two choices for accessing external data sources.
You can create queries, forms, and reports that use the external data, combine the external data with the data in Microsoft Access tables, and even view and edit the external data while others are using it in the original application.
External data falls into two categories: indexed sequential access method (ISAM) and Open Database Connectivity (ODBC).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.The ISAM data sources are traditionally computer-based databases.These include Microsoft® Fox Pro® database management system, Paradox®, Microsoft Access, and others.
You can either link the tables to a Microsoft Access database or open the tables directly.