Access updating using linked tables

Some people settle for this but there may be a simple way to significantly improve performance. This is not a big deal for a single MS Access database application which would create the lock file when the database is opened and maintain it until the database is closed.

access updating using linked tables-48access updating using linked tables-64access updating using linked tables-34

The interaction of these two engines can sometimes yield results that are inferior to those obtained by using only the Jet database engine with native Office Access tables.

When you link an Access table to a SQL Server or SQL Azure table, the Jet database engine stores connection information and table metadata, but the data is stored in SQL Server or SQL Azure.

This lets your Access applications operate against the Access tables even though the actual tables and data are in SQL Server or SQL Azure.

Though Access can be considered a sub-par application by the relational database elitists, it can be a very capable alternative for querying data from SQL Server without the learning curve associated with Visual Studio.

In some respects, it is the perfect tool for the casual business user who wants to drill into and share their data. In order to connect to Microsoft SQL Server from Microsoft Access you need to set up at least one Linked Table.


Leave a Reply