|
We are using Access 2000 database, with the following settings.
Tool > Options > Advance >
Default Record Locking = Edited Record
Open databases using record level locking = True
Form property >
RecordLock = Edited Record.
However, the record is still NOT locked. Multiple users can still open
and edit the record at the same time. And the second person who tried
to save will get error message, the update confict message as in "No
Locking" setting.
I'm using bound form. How can I set it such that only one user can
open the record for editing at any one time? Our file server is
Windows 2003 server running DFS (distributed file system).
I googled through this group, but most of the discussions were that
records got locked unnecessarily. My problem is the opposite of that.
I couldn't find this topic in the Access Web as well. I hope someone
here can help... Thanks in advance.
| 
