Hi there,

I would like to ask whether it is possible to bypass the lock on an external DB that is being used by another person. I am trying to achieve this through GUI using VB.

I am asking this because I can open that DB manually by double clicking on it (it being locked still, with the .ldb file present in the same dir. as the DB), but when the VB code tries I get the follwing error message:

Runtime Error '3356':
You attempted to open a database that is already opened exclusively by user <name> on machine <name>. Try again when the database is available.


Any help or advice would be very much appreciated, Thank you for your help and time.

Kind regards

Derek

You need to get the other users to open the database in "shared" mode. Then multiple users can open the database at the same time.

Boyd
"Hi Tech Coach"
Access Based Accounting/Business Solutions developer.
http://www.officeprogramming.com