using linked table manager to update path on linked tables

[Nydia]

I have a database that has tables linked to it from
another database, and it needs to be moved to another
location. When it was moved, it didn't work, because the
linked tables couldn't find the correct path. I was told
to use the linked table manager to update the paths, but
can someone let me know how to do it? Do I move the
databases first? Do I have to update one link at a time?
How does this work?? Any help is greatly appreciated.

 

[Kevin3NF]

Move the database that has the tables (back-end) first.

Use tools>>database utilities>>Linked table manager. You select your tables
one by one, or all at once. Click OK and browse (go through network
neighborhood or my network places) to the new lcoation of the back-end file.

 

[Joan Wild]

Move the database that has the tables (back-end) first.

Use tools>>database utilities>>Linked table manager. You select your tables
one by one, or all at once. Click OK and browse (go through network
neighborhood or my network places) to the new lcoation of the back-end file.

Just a minor correction, as many seem to overlook this, don't forget to put
a check in the box at the bottom of dialog before you click OK - 'Always
prompt for new location'

 

[Kevin3NF]

Please correct me I am wrong, but if the existing path points to a file that
has been moved (not copied), won't the browse dialog come up anyway?

 

[Joan Wild]

I stand corrected. I thought I remembered that you just got an error.
Thanks for that.