Linked .mdb failure

G

Guest

I have a Schedule db opened and it runs a routine by timer event in an open
form every 15 minutes to update files contained within it.

I have another db that links to that db's tables. If I open the Schedule db
first and then try to open the Reports db I get the following message.

Could not use; file already in use

If I open the Reports db first, then the Schedule db there doesn't seem to
be a problem but....

The Schedule db needs to be running persistently so it's important that I be
able to open the Reports db subsequent to opening the Schedule db.

Any help?
 
G

Guest

Can you reverse the direction of your linked tables. Perhaps the wrong db is
holding the base tables?
 

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

Similar Threads

Linked Table DB Won't Open if BE DB is Moved 4
Linked table problem 1
Database Expanding out of Norm 3
Hide ldb file 5
Cannot Convert Access 2002 DB To Access 2007 6
Creating custom property 1
Delete/import a table from csv; wait for no users? 2
Run a VBA Sub using Windows Scheduler? 5

Top