Temporarily linking to a BackUp DB,when another link is present

M

Mota

Hi;
I have splitted my database to 2 DB.One is CodeDB in
C:\MyDataBase\PrescriptionProcessor.mdb and the other is DataDB containing
tables in D:\Data\DataDB.mdb.At the end of each month user may make a new DB
and send a copy of all tables(preserving their names) from DataDB to this
new database,in a desired path (e.g. E:\BackUp\DataDB.mdb).
Now what i want to do is to make a link to one of this backups,So the user
can interact backed up tables through their relative forms,rather than
working with a table directly.I tried to do this ,but when a table links ,a
"1" is added to the end of its name (for there is another linked table under
this name),so relative form wont use it as its record source.It seems that i
have to remove all links to the current month DataDB befor linking to a
backed Up DataDB(even if user needs back up tables for just a few
seconds).All this procedure must be done thru code.
Is there a simple way to link to another db temporarily and for a short
time,and then get back to the main data source,through code?
Any help would be appreciated.Thank you in advance.
 

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