Setting up Access dbase so only one user can alter records at a time

B

BLG

I have an Access 2000 dbase that is used by multiple
users. We want to set up the dbase so that only one user
can change data in that table at a time.

As it is set up right now, multiple users can use the
tables in the dbase and alter data simultaneously.

Please advise on how to resolve this.
 
J

JohnC

Hello,

If you go into to the properties of the form itself and change the "Record
Locks" property to "Edited Record" this should solve your problem.
 
Top