Remove Exclusive Access to Database

[RST]

I have a database that I created using Access 2003. Someone on our network
has opened the database exclusively, so when I try to open it it's opening
read-only. I have no idea who has it opened exclusively and no way of finding
out who it is. I need to somehow either kick that user out of the database,
or at least wrestle the exclusivity away from him/her. Is this possible?
Thanks.

 

[boblarson]

If you open the ldb file you should be able to see which computer names have
the file open. The trick is to figure out who has which computer (you might
have to get your IT/IS team involved.

Second, you should not have multiple users opening the same mdb file. If
you are in a multi-user situation then you should split the database and the
backend be on the file server and a copy of the frontend be put on EACH
USER's machine.

See here for more about that:

http://members.shaw.ca/AlbertKallal/Articles/split/index.htm


--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________