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

  • Thread starter Thread starter BLG
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dbase Crazy Flicker Crash 3
Viewing an Access Dbase 1
Conversion Advice 1
Multiple users able to access MS Access 2003 Dbase 1
ldb files 3
can you recreate an old record with same id? 8
Unlocking an Access Database so multiple users can access it. 2
Using Macro to Alter Multiple Pivot Tables 1

Back
Top