Updating data in a linked table

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.

updating data in a linked table-58

The weird issue is that, if I check a linked table from the application, the data is stale.

You can link the tables either by using the user interface or from Microsoft Access Basic.

It is also possible to open external databases directly from Microsoft Access Basic.

Although your particular situation might require you to open the data directly, it is best to consider linking if possible.

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.

Leave a Reply