How do I trace down user of Access database?

D

dwz

I'm locked out from an Access mdb created originally by myself.
I get a warning like I can only open it in Read Only because it's opened by
someone else at the same time.
Is there a way to trace down the user so I can alert him or her to get out
of the mdb.

I need to resume the right of changing the mdb.

If you think there might be other reasons which prevent me from changing the
mdb, please advise how I can get rid of the error message.
 
T

Tom Wickerath

Hi DWZ,

This can happen if there is a left over locking database file (*.ldb)
hanging around. The following KB article discusses causes of this, which
include the last user exiting does not have delete privlege, or the database
is starting to corrupt:

Introduction to .ldb Files
http://support.microsoft.com/?id=299373

Try downloading the AppUser tool from the MVPS website:

http://www.mvps.org/access/modules/mdl0055.htm


Tom

http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

:

I'm locked out from an Access mdb created originally by myself.
I get a warning like I can only open it in Read Only because it's opened by
someone else at the same time.
Is there a way to trace down the user so I can alert him or her to get out
of the mdb.

I need to resume the right of changing the mdb.

If you think there might be other reasons which prevent me from changing the
mdb, please advise how I can get rid of the error message.
 
Top