(mysql.info) linked-tables
Info Catalog
(mysql.info) import-of-data
(mysql.info) msaccess
(mysql.info) deleted-problem
23.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*:
1. Open the database that contains links to tables.
2. On the `Tools' menu, point to `Add-ins' (`Database Utilities' in
Access 2000 or newer), 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 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*:
1. Open the database that contains links to tables.
2. On the `Tools' menu, point to `Add-ins' (`Database Utilities' in
Access 2000 or newer), and then click `Linked Table Manager'.
3. Select the `Always Prompt For A New Location' check box.
4. Select the check box for the tables whose links you want to
change, and then click `OK'.
5. In the `Select New Location of' <table name> dialog box, specify
the new location, click `Open', and then click `OK'.
Info Catalog
(mysql.info) import-of-data
(mysql.info) msaccess
(mysql.info) deleted-problem
automatically generated byinfo2html