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? I have already asked the other user to look for the .ldb file but they don't always pay attention...if they log in while another user in logged in it corrupts the database. I need a way to prevent the database from opening all together. I have also changed the default opening option to "Exclusive" but they can still log in while another user in logged in. Does anyone know if this is possible?