Oracle 5.0, Reference Manual

Page: 1800 / 3232

Connector/ODBC Examples
1780
6. If Microsoft Access is unable to determine the unique record identifier for a table automatically then
it may ask you to confirm the column, or combination of columns, to be used to uniquely identify
each row from the source table. Select the columns to use and click OK.
Once the process has been completed, you can now build interfaces and queries to the linked tables
just as you would for any Access database.
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 MySQL 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
.