Exclusive mode

  • Thread starter Thread starter SHIPP
  • Start date Start date
S

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.
 
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.
 
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
'====================================================
 
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?
 
Back
Top