Linked Table Manager not updating tables simultaneously

[Guest]

I have a back end on a remote server and a front end on my desktop. To work
with a copy of the back end on my hard drive, I would like to change the
table links from the network server to the hard drive via the Linked Table
Manager. Per a suggestion posted to another newsgroup user, I checked that
all tables are pointed to the same back end and all file paths have the
\\server\...\backend.mdb address (rather than a hard drive letter). Then, I
tried re-linking the tables to point to the back end copy on the hard drive.
However, Access is still prompting the back end location for every single
table. I would much prefer that it prompts the location only once and
updates the links for all selected tables like it has done for years until I
got Access 2003. Do you have a possible solution to this?

Cheers,
Suzan

 

[Roger Carlson]

My experience is that it only does that when tables are linked to two or
more separate database files. If ALL of the tables come from the same
database, it should only prompt you once.

Another alternative is to relink your tables programmatically. On my
website (www.rogersaccesslibrary.com), are a couple of small Access database
samples called "LinkTables.mdb" and "RelinkOnOpen.mdb" which illustrate how
to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks for your response. I checked once more, and all tables were pointed
to the same back end. Though, I had a hunch to what the problem may be. One
table had some capital letters in the file path of the back end whereas all
other tables did not. Relinking this table to the server so the upper- and
lowercases are the same as the file path for all other tables and then
changing the links from the server to the hard drive solved the problem.
Access prompted only once.

 

[Albert D. Kallal]

Thanks for your response. I checked once more, and all tables were
pointed
to the same back end. Though, I had a hunch to what the problem may be.
One
table had some capital letters in the file path of the back end whereas
all
other tables did not. Relinking this table to the server so the upper-
and
lowercases are the same as the file path for all other tables and then
changing the links from the server to the hard drive solved the problem.
Access prompted only once.

WOW..that makes sense. Thanks for sharing that with us, I not seen this
explained before, but it certainly would cause your problem (now that you
explained that to us!!).