Microsoft Access – How to update linked tables

By Tom Chandler on April 29, 2013 in Access, Databases

Open your Access database.
Start the Linked Table Manager feature.
- In Access 2003, from the menu choose Tools, Database Utilities, Linked Table Manager.
- In Access 2007 from the ribbon choose Database Tools, Linked Table Manager.
- In Access 2010 from the ribbon choose External Data, Linked Table Manager.
In the Linked Table Manager dialog box:
1. Choose the “Always prompt for new location” check box.
2. Click the “Select All” button.
3. Click OK.
In the Select New Location dialog box find select the desired data file and click Open.
When the database informs you that all tables have been successfully refreshed, click the OK button.
Close the Linked Table Manager dialog box by clicking the Close button.
Optional: Exit and restart the database so the startup routines will take affect.