Advantage of Record-level locking
- Useful where many users are editing at once.
- Slower performance, and probably less tested.
The only serious problem I have experienced was with a JET 4 front end
connected to an Access 97 back end. If record-level locking was enabled,
some fairly involved action queries executing inside a transaction failed toReference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12462
run to completion. Disabling record-level locking in the front end solved
the problem. Since Access 97 did not have record-level locking, the front
ends should have just ignored the setting. We experienced this in Access
2000 and in 2002.
In general, therefore I suggest you use page-level locking unless you have a
need for record-level.
Allen Browne - Microsoft MVP. Perth, Western Australia.Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=12462
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"simcon" wrote in message
> which is the better locking option to use?
> are there occassions when you would use one in preference over the other?
> do both locking methods work equally well?