Exclusive mode

[SHIPP]

I have checked the box for Exclusive mode under Advanced Options. I have also
checked Default Record Locking for All records. I then open the database on
one machine. I then log on to another machine and open the database. It opens
just fine. How come it is not locking the second machine out? When I check
the options on the second machine Default open mode is set to Shared. Default
record locking is set to no locks. Please explain.

 

[SHIPP]

The bottom line is that if one user has it open I do not want any other user
able to open it at the same time.

 

[John Spencer]

Set record locking to ALL RECORDS. That will lock all records in a
table when the table is in use by any user - which will prevent any
other user from making changes.



'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[SHIPP]

That seems to work. However, how do I prevent anyone else from even opening
the database?

 

[SHIPP]

That works just fine. However, I do not want any user to even open the
database when another user is in it. Is there a way to do that?