Linking Tables From Another DBS

[joesmithf1]

Hi,

I have a 'main' database named(A), and I have 2 tables that I have linked from two other databases(B and C). NOTE: I kept all this 3 databases(A,B,C) in one folder named 'Joe' on my workstation.

Here is the issue, every so often when I open my 'main' database, and I need to query the tables in B or C(which I have already linked to in my main database), I get an error message saying something like "path to c:\...\B is not found." To fix this issue, I have to use the "Linked Tables Manager" tool to relink all the tables again. As you can this, this is causing me a lot of unnecessary wasted time. What will i have to do to have these tables linked permantely so that I don't have to relink everything?


Thank you.

Joe

 

[MarkK]

Put all your tables in one database? Is this a trick question?

 

[Dennisk]

I think Joe is saying he has broken links. possibly the links are being maintained only while the db A is open.
If that is the case then I have never come across this.

If this is the case then set the system tables to visible and see what the link is :-
A. After linking , using the table and exiting db A.
B. After opening Db A and the query fails.

the system table is msysObjects and the link information is in the column [Database]

 

[joesmithf1]

Of course i am NOT putting ALL the tables into one database! This is the main reason i am LINKING to tables in other database just so I can keep my 'main' database(A) to a minimal.

After I have linked to other tables(from other databases), I have NO problem running queries against them. HOWEVER, every so often I get broken links to these tables and I have no idea why Access is doing this.

ALSO, I am able to fix these broken links by using the "Linked Tables Tool" BUT how would I prevent this from happening again in the future so that I don't have to fix it all the time?

Dennisk, you mentioned "msysObjects and the link information is in the column [Database]." Is this where i check the broken links? Will this fix the issue i mentioned above?

thank you!

Leon

 

[Dennisk]

No, this will not fix your problem, but it may give you a handle on it.