[Access 2003]

If you would like to view or to refresh links when the structure or location of a linked table has changed. The Linked Table Manager lists the paths to all currently linked tables. Here's how:

1. Open the database that contains links to tables.
2. On the Tools menu, point to Database Utilities, and then click Linked Table Manager.
3. Select the check box for the tables whose links you want to refresh.
4. Click OK to refresh the links.

Microsoft Access will confirm a successful refresh or, if the table wasn't found, it will display the Select New Location of <table name> dialog box, then you can specify the table's new location.

If several selected tables have moved to the new location that you have specified, the Linked Table Manager will search that location for all selected tables, and it will update all links in one step.