26.1.11.4. The Structure or Location of a Linked Table has been Changed. Can I See Those Changes Locally in Linked Tables?
Yes. Use the following procedure 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.
To view or refresh links:
Open the database that contains links to tables.
On the Tools menu, point to
Add-ins (Database
Utilities in Access 2000 or newer), and then click
Linked Table Manager.
Select the check box for the tables whose links you want to
refresh.
Click OK to refresh the links.
Microsoft Access confirms a successful refresh or, if the table
wasn't found, displays the Select New Location
of <table name> dialog box in which you can
specify its the table's new location.If several selected tables
have moved to the new location that you specify, the Linked
Table Manager searches that location for all selected tables,
and updates all links in one step.
To change the path for a set of linked
tables:
Open the database that contains links to tables.
On the Tools menu, point to
Add-ins (Database
Utilities in Access 2000 or newer), and then click
Linked Table Manager.
Select the Always Prompt For A New
Location check box.
Select the check box for the tables whose links you want to
change, and then click OK.
In the Select New Location of <table
name> dialog box, specify the new location, click
Open, and then click
OK.
