I have been experiencing problems with record locking. Most people seem to
struggle with unwanted locks but my problem is that I cannot seem to get
record locking to work. I first spotted the problem on an application that
was causing problems due to users changing the same records. Whatever I do I
cannot get the records to lock and I am experiencing the same problem on a
small test db designed to investigate the problem.
I have set the database options as follows (which is my preferred option): Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/7089-record-locking-problem.html
Open Database use record-level locking - true
Deafult open mode = shared
Default Record Locking = edited
I have also checked that the forms and queries have the record locking
option set to "edited record"
This SHOULD allow me to view the same record with two different forms butReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7089
not let me make changes - but I can change the records!!!
I have tried playing around with the options but all setups and tried it
with a standalone and a split database but it still allows me to change
I am using Access 2003.
Am I missing an obvious trick?