Linking two tables problem

M

Michiel Timmermans

We have the following situation:
A first database TEST1.mdb in c:\test.
A second database TEST2.mdb also in c:\test.
In the second database some tables are linked the the same
table in the first database.

Now we want to move both databases to another directory
(f.e. d:\production).
When we now open the second database and want to open one
of the linked tables we get the message:
Could not find file 'c:\test\TEST1.mdb'.
It is logical because the database isn't there anymore.

The question is the following:
Is it possible, and if so how, to link two tables and the
upper situation will work? So the link in the second
database should read the link without pathname.
Notes: 1. We don't want to link every single table again.
2. Both databases are always in the same directory.

Thanks in advance,

Michiel Timmermans
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top