Linked Tables Update Problem

[neenmarie]

I use several databases linked back to a main database's tables. I take
copies home to work on and need to take them back to work and update the
links. I'm having a problem with one database in particular that will not
allow me to select all linked tables, browse out and find the main database
to update the links. I browse out to the sub-folder storing the main
database and select the database, but it just keeps flipping back to the main
folder.

It will allow me to select a few tables at a time (sometimes only one) and
update. But, now all or even most of them at once. This can be very time
consuming.

Any idea what may be wrong?
Thank you

 

['69 Camaro]

I browse out to the sub-folder storing the main

database and select the database, but it just keeps flipping back to the main
folder.

It will default to the Default Database Folder setting when first opened,
but it "remembers" the directory where a file was selected during the current
session and opens that directory first on subsequent imports, exports or
linking of tables. I don't know why yours isn't behaving properly. Keep
backups and do compact/repairs on a regular basis. You may want to create a
brand new database file and import all the objects into this new file.

However, there's a work-around. Create a button on a form that runs VBA
code that prompts you for the directory and then creates the links for you.
For the necessary code, please see the tip, "Relink Access tables from code,"
on the following Web page:

http://www.mvps.org/access/tables/tbl0009.htm

Please see the tip, "Call the standard Windows File Open/Save dialog box,"
on the following Web page:

http://www.mvps.org/access/api/api0001.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.