:: DEVELOPER ZONE
MySQL Reference Manual :: 25.1.11.4 The Structure or Location of a Linked Table has been Changed. Can I See Those Changes Locally in Linked Tables?
Search the MySQL manual:
- 25.1.11 MyODBC and Microsoft Access
- 25.1.11.1 How to Set Up Microsoft Access to Work with MySQL using MyODBC?
- 25.1.11.2 How to Export a Table or Query from Access to MySQL?
- 25.1.11.3 How to Import or Link MySQL Database Tables to Access?
- 25.1.11.4 The Structure or Location of a Linked Table has been Changed. Can I See Those Changes Locally in Linked Tables?
- 25.1.11.5 When I Insert or Update a Record in Linked Tables, I Get #DELETED#
- 25.1.11.6 How Do I Handle Write Conflicts or Row Location Errors?
- 25.1.11.7 Whenever I Export a Table from Access 97, a Strange Syntax Error Occurs
- 25.1.11.8 Access Returns Another user has modified the record that you have modified While Editing Records
- 25.1.11.9 How to Trap ODBC Login Error Messages in Access?
- 25.1.11.10 How Do I Optimize Access for Performance with MyODBC?
- 25.1.11.11 I Have Very Long Tables. What is the Best Configuration for MyODBC to Access These Tables?
- 25.1.11.12 How to Set the QueryTimeout Value for ODBC Connections?
- 25.1.11.13 INFO: Tools to Export/Import from/to Access to/from MySQL
Additional languages
Additional formats
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
Toolsmenu, point toAdd-ins(Database Utilitiesin Access 2000 or newer), and then clickLinked 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
Toolsmenu, point toAdd-ins(Database Utilitiesin Access 2000 or newer), and then clickLinked Table Manager.Select the
Always Prompt For A New Locationcheck 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, clickOpen, and then clickOK.
© 1995-2005 MySQL AB. All rights reserved.
User Comments
Warning: query failed: Unknown column 'user.firstname' in 'field list' in /data0/sites/live/web-main/lib/mysql-cxn.php on line 69
Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /data0/sites/live/web-main/lib/docbook.php on line 245
Add your own comment.