Linked table - source moved, how to up date link

intelogent
intelogent used Ask the Experts™
on
hi,

we are using MS office 10 Pro.  a table was linked to a DBF.  that DBF has moved. how do I re-establish the link ?
I have tried to use the linked table manager, but there is no opportunity that I see which allows this...

any help please.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
In the linked table manager there should be a check box that reads "Always prompt for new location" or something to that effect. Check that box and the box for that table before clicking OK and you should be prompted for the location with a dialog box.
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015
Commented:
from the ribbon:
External Data, Linked Table Manager
check the box to the left of the table you wish to re-link
check: Always prompt for new location
and then click OK

then Browse to the BE (BackEnd) database.  If you do not see a file listed and you know it is there, type: *.* and press ENTER in the filename box.

Sometimes it is easier to delete a link and create the link again.

Be sure to backup the database before you start changing the links ~
Database Architect / Application Developer
Top Expert 2007
Commented:
Linking to DBF file may be somewhat different - it's been awhile

And in general re "In the linked table manager there should be a check box that reads "Always prompt for new location" or something to that effect." ... be absolutely SURE you check that option, otherwise you can easily be fooled the relinking occurred to the new location - especially if the original location still exists.

Author

Commented:
its nice when three people all agree and one has learned

happy holidays
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and Programming
Top Expert 2015

Commented:
have a joyous new year ~ you're welcome, happy to help

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial