How can I allow only 1 user at a time in an Access 2007 database?

  • Thread starter misswhitneypaige
  • Start date
M

misswhitneypaige

I would like Access to display the "read-only" message that Excel does when a
user attempts to open a file that is already in use by another user. How can
I make that happen in 2007?
 
T

theDBguy

Hi,

Access is a multi-user application, so it sounds very odd that you don't
want multiple users using your database at the same time.

In any case, you could try giving each user a shortcut to a batch file or a
VBS script that checks for the existence of the .ldb file before opening
Access. If the .ldb file already exists, the file is already being used by
another user. Your script can then inform the user to try the file again
later.

Hope that helps...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File in use by another application or user 2
Autonumber field in Excel that behaves the same as Access 0
How can I install Publisher in 365 Enterprise? 1
ASK Field Formatting 1
Allow more than one user on a database 3
How can I allow only 1 user at a time in an Access 2007 database? 2
How to create portable Excel applications? 2
Make "File in use" message appear when 2 people open the a shared document in the same time 3

Top