how tell who has file open?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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
 
Back
Top