Restricting Access to 1 User?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
 
Back
Top