Updating linked tables in ms access

We just experienced major ODBC errors with our front-end MS Access 20 solutions and the problem began when Microsoft pushed several security updates to our PCs.We eventually discovered that the problem was caused by the KB2820197 update and everything began to work properly after we uninstalled this update from several PC systems.

After we uninstalled update KB2820197, all the update queries began to work.

This is occurring on both Windows XP (running MS Access 2007) and Windows 7 systems (running MS Access 2010).

You can open a linked table in Design view to change the Format, Decimal Places, Caption, Description, and Input Mask property settings for any field.

You can set these properties to customize the way you look at and update data in Access forms and reports.

You can also give any linked table a new name for use within your Access database (although the table's original name remains unchanged in the source database) to help you better identify the table or to enable you to use the table with the queries, forms, and reports that you've already designed.

Changing a table's design in Access has no effect on the original table in its source database.

If you move some or all of your linked tables to a different location, you must either delete your linked tables and relink them or update the location information before you can open the tables.

You can easily update the location information in the table links by using the Linked Table Manager.

If anyone has any additional information about this issue, please post.

Tags: , ,