Linked table - source moved, how to up date link

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.
intelogentAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

DougCommented:
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 ProgrammingCommented:
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 ~
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Systems AnalystCommented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
intelogentAuthor Commented:
its nice when three people all agree and one has learned

happy holidays
crystal (strive4peace) - Microsoft MVP, AccessRemote Training and ProgrammingCommented:
have a joyous new year ~ you're welcome, happy to help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.