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

  • Thread starter Thread starter misswhitneypaige
  • Start date 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?
 
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...
 
Back
Top