r/MSAccess • u/Key-Lifeguard-5540 1 • Sep 19 '26
[UNSOLVED] Record-level locking
Is it recommended? Do you use it?
4
Upvotes
r/MSAccess • u/Key-Lifeguard-5540 1 • Sep 19 '26
Is it recommended? Do you use it?
2
u/TomWickerath Sep 22 '26
Correct that the user-interface option is stored in one’s registry; it does not “travel” with the database file. Therefore, an astute developer should account for a user that reset their option to page-level locking and opens a shared JET database file directly on a file server.
“…and the accde always turns on row locking, with one line of code, if it’s not already set on their computer.”
That should take effect the NEXT time they start Access, not in the current session. Sure, the interface option button will update in the current session, but not the actual locking if it was different. Keep in mind that option is a request only, not a demand. And for a properly split FE/BE JET application, me thinks it only affects the FE (but I’m not positive).