Form.RecordLocks=EditedRecord: Is it that simple?

[(PeteCresswell)]

Access 2003/Access 11.

If I just set the form's .RecordLocks=EditedRecord will that
allow other users to edit records in the same block?

i.e. Will only the current row be locked - and not the entire
block it resides in?

Seems too easy..... -)

 

[Allen Browne]

That should be the case if you also check:
Open Databases using record-level locking
under:
Tools | Options | Advanced

However, if another user who is not using record-level locking opens the
database first, you are back to page-level locking, so you are back to page
locking again.

Pete, I probably should also mention that I've had some code fail when
record-level locking is turned on. The code was for merging a duplicate
client into another, along with all their related records (so several tables
affected) inside a transaction. Once record-level locking as turned off, the
code ran fine.