concurrent edit problem

[polina]

Hi

I have a form for the record modifications.

What I want to do is if the record is being modified, I want that another user wouldn't be able to open the form for the modification of the same record

Is this possible to achieve?

Thanks

 

[afloyd]

you can lock the record by using "pessimistic" record locking. I don't know if it prevents viewing of the form.

Go to HELP -> INDEX keyword RecordLock and it will tell you all about setting the property.

HTH

-Al

 

[charityg]

Tools->Options, Click the Advanced tab.

Select Edited Record from the Default Record Locking option group.

 

[sarahb845]

If you use the Tools - Options settings, do you also have to go into each form & report and set it's record locking to from No Locks to Edited Records?

Does the Tools - Options setting over-ride the record locking setting at the form level?

 

[Cosmos75]

About locking records when you have a multi-user database.
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=2876

Hope this helps!