Linked Tables headache

[Stapes]

Hi
I have a database with 43 linked files. Normally, when I need to link
it to a new version of the back end, I use the Linked Table Manager, I
thick Always Prompt for New Location, then click on Select All, then
browse to where the back end is, and it links all the tables. Now, it
is asking me again for each individual table. This is totally
unacceptable from the clients point of view. 1) It takes all day. 2)
It's too much can go wrong.

Is there any way I can write my own routine to do this properly?

Stapes

 

[Douglas J. Steele]

See http://www.mvps.org/access/tables/tbl0009.htm at "The Access Web"

 

[Peter Hibbs]

Also :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

HTH

Peter Hibbs.

 

[patrick.f.kryzsko]

Hi
I have a database with 43 linked files. Normally, when I need to link
it to a new version of the back end, I use the Linked Table Manager, I
thick Always Prompt for New Location, then click on Select All, then
browse to where the back end is, and it links all the tables. Now, it
is asking me again for each individual table. This is totally
unacceptable from the clients point of view. 1) It takes all day. 2)
It's too much can go wrong.

Is there any way I can write my own routine to do this properly?

Stapes

To get around this, I've always just re-linked one of the tables, then
renamed removing the 1 created at the end. Then compact and recompile
or exit and re-open.

 

[Pat Hartman]

The problem is that all selected tables are not from the same back end. The
linked tables manager is pretty restrictive. I didn't look at the code
examples but you may need to modify them if they have the same problem to do
one be at a time.