tech on the net
Home About Us Feedback Site Map

Microsoft

Access Excel Word

Database

SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker

Language

C Language

More

ASCII Table Linux UNIX Java Clipart Joke of the Moment

Other Sites

CheckYourMath BigActivities DigMinecraft
Share this page:

MS Access: Refresh table links in Access 2007

See solution in other versions of Access:

Question: In Microsoft Access 2007, how can I refresh all table links without having to delete the link and recreate it?

Answer: To do this, under the Tools menu, right-click on the linked table in the left window. And select "Linked Table Manager" from the popup menu.

Microsoft Access

A Linked Table Manager window should appear as follows:

Microsoft Access

Select the tables that you wish to refresh the links for. In this example, we've selected the Suppliers table. Click on the OK button.

Microsoft Access

You should get a message indicating that the linked tables were successfully refreshed. Now, any changes to the linked table should be reflected in your database.

Microsoft Access

This will return you back to the Linked Table Manager window. Click on the Close button.