Show that it is already open or only let one in at a time

  • Thread starter Thread starter Bonnie A
  • Start date Start date
B

Bonnie A

Hi everyone,

Happy new year! Using A02 on XP. Have my DB's in a multiuser environment in
a shared drive. I have one lone DB that needs to be a single user file.

How can I make the shortcut open it exclusive? Is that the easiest solution?

Should I have a form that shows current users? I have a ShowUsers Module
but don't know how to 'read' results into a field on a form.

Can I have a message box open saying "Someone else is currently using the
file, please try again later"?

Can I have the main form that opens on AutoExec not allow more than one
person to have it open?

Need a quick fix, if at all possible as it is already in production.

Thank you in advance for all your help and advice. I really love the
newsgroups.
 
Bonnie

Are you saying that you have a single Access .mdb file? That you haven't
split the database to a front-end (a copy of which resides on each user's
PC) and a (single) back-end on a server that all can reach via a LAN?

You've described a "how" (how do I open an Access database 'exclusive' in a
multiuser environment).

"Why?" Access is, out of the box, a multiuser application. What business
need are you attempting to solve by preventing multi-user use?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top