Linked table manager - Linking multipe tables

[Guest]

I am linking approximately 30 tables to my DB but frequently move the front
end and back end to my home for futher development. At home, I link my table
to another computer with a different drive structure so I can't use the same
linking directive as I do at my office.

For months, the Link table manager would require I link to the first of my
tables to the new location and would then automatically link all of the other
tables. For some reason it has stopped doing this and now requires that I
manually link each of the 30 tables. Any ideas on how to make this work
automatically again?

Thanks

 

[Guest]

It is quite common to use code to automatically re-link tables at startup.
This avoids the hassle of using the linked table manager. In the past, I have
experienced exactly what you describe, but I'm not sure of the cause. In any
case, if you are willing to try using a code solution, you can relieve
yourself of this drudgery.

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


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Pat Hartman\(MVP\)]

There is a box at the lower left of the dialog named "always prompt for new
location". Check it. You will then be prompted to supply a new location
for all the existing links.

 

[Armen Stein]

Usually this indicates that at least *one* of your tables is linked
differently than the others. Access will automatically use the same path
for all of them, but they have to all be identical. Once you get them all
the same again using Pat's suggestion, Access should go back to asking you
just once.

 

[Guest]

Usually this indicates that at least *one* of your tables is linked
differently than the others. Access will automatically use the same path
for all of them, but they have to all be identical. Once you get them all
the same again using Pat's suggestion, Access should go back to asking you
just once.

--
Armen Stein
Microsoft Access MVP
J Street Technology, Inc.
www.JStreetTech.com





I found the solution to this problem and returned to post the answer. I found the above suggestions as well.

For future reference for myself and others, here is what I discovered.
First, everyone is right, to some extent. I found that if there is one or
more tables located in a different location you must enter the location for
each table separately. If, on the otherhand, all tables are located in the
same location, and you unselect the promt box, it will automatically link
all the tables at the same time. Solution, therefore, is to make sure all
tables to be linked are in the same location.

I tried the code suggested with Office 2003 Access SP2. It asked for
another function discussed in the code example. I used it as well, and it
still had errors beyond what I wanted to mess with, so I returned to solve
the problem as discussed herein.

 

[Pat Hartman\(MVP\)]

You can use multiple back ends. You simply select only the tables from a
single be at one time.