Record Locking

C

Crossh

I'm using an Access database fe which is linked to a Sql Server be containing
all the tables.

In the Advanced Options, I set the Default Record Locking to Edited Record.

On the Form I set the Record Locks property to Edited Record. However,
multiple users can still open up the form with the same record on it and edit
it simultaneously. How can I stop multiple users from opening up the same
record at the same time?
 

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

Access Lock File .LACCDB / Now shows as a notepad file 0
Copy previous record into form field 0
Record Locking Multiuser 1
Hide/Skip Records that have "Edited Records" Record Lock 2
Record Locking 2
Make "File in use" message appear when 2 people open the a shared document in the same time 3
Listbox row source and record locking? 1
Access 2003 application slow when multiple users are on. 9

Top