By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,656 Members | 800 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,656 IT Pros & Developers. It's quick & easy.

Cannot open same table using Access 2.0 and Access 2003 in the sametime

P: n/a
I'm unable to to open a linked table T that is stored in an Access 2.0
MDB database file (shared/back-end,) using both Access 2.0 and Access
2003, in the same time.

Here is the scenario:

1- Start Access 2.0 and open the linked table T.
2- Start Access 2003 then try to open the same linked table T.
3- You may get the error "Could not use <.mdb file name>; file already
in use."

It seems Access 2.0 "Locks" the table for exclusive use, but how to
explain that another instance of Access 2.0 still CAN open the same
table in the same time!

Please note: Access 2.0 and Access 2003 runs on two separate machines,
while the shared/back-end mdb file is stored on a third machine.

Please note upgrading the back-end database to 2003 is NOT a feasible
solution in the current time!

Thanks
Jun 27 '08 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.