how tell who has file open?

[Guest]

Thanks for any help.
Is there a way to tell who has a Access database open? Sometimes at our
company we have someone that needs to modify it, but someone has already
opened it, and all we can do is wait for the person who opened it to close.
We send out an email to everyone (60 people in the dept), but they might be
at lunch, etc.
If we knew who had it open, we could go tell them to close, etc.
Thanks again.

 

[Guest]

Check this post on the same subject

http://www.microsoft.com/communitie...user&mid=2d5b113d-c839-4a58-a2db-12fe45a02741

 

[Van T. Dinh]

See the Microsoft Knowledge Base article:

http://support.microsoft.com/?id=198755

or:

http://www.tek-tips.com/faqs.cfm?fid=4894

 

[Ron2005]

Try this link: http://www.mvps.org/access/modules/mdl0055.htm

it has a small access app that looks at the ldb file and will tell you
all of the users that are logged into mdb that you reference.

really neat and small, and the code for the form can be imported into
any app that you want or run standalone out of this app.

Ron