Restricting Access to 1 User?

D

dml

We have an Access database on a shared network. There are 2 users who use this database. However, we only want 1 user to be able to log into the database at any given time. Is there a way restrict the Access database to only 1 user at a time? If a user is logged in and another user tries to log in, can the database give them a message as such and deny their access?
 
V

Victor Delgadillo

Check for the existence of the ldb file with the same root as the mdb. That
means someone is (or was and left hanging) the database.

--
Victor Delgadillo [MVP Access]
Miami, Florida

Consultas al grupo, asi todos nos beneficiamos.

_
dml said:
We have an Access database on a shared network. There are 2 users who use
Click to expand...
this database. However, we only want 1 user to be able to log into the
database at any given time. Is there a way restrict the Access database to
only 1 user at a time? If a user is logged in and another user tries to log
in, can the database give them a message as such and deny their access?
 

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

Access Lock File .LACCDB / Now shows as a notepad file 0
Restricting User Access In Access 2010 Sharepoint With Hydrated Database 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
Sub projects added as read only in Master file which are saved on sharepoint 1
Default local file location - folder redirection slowness 0
Microsoft 365 Activations, Users or Devices? 0
Outlook Desktop (latest) stopped syncing IMAP accpounts from selfowned Mail server. 0
Problem with multiple database users 4

Top