If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Show that it is already open or only let one in at a time
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 W. Anderson Cincinnati, OH |
#2
|
|||
|
|||
Show that it is already open or only let one in at a time
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 "Bonnie A" wrote in message ... 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 W. Anderson Cincinnati, OH |
Thread Tools | |
Display Modes | |
|
|