! DAO Record Locking !

[Wembly]

Hi,

I was wondering if there is a way to lock only ONE record
in Access using the pessimistic locking technique, and
also NOT padding the rows with additional columns to take
up any residual memory which Access by defaults allocates
2048 bytes?

Thanks.
Wembly

 

[Allen Browne]

In Access 2000 or 2002 you have the option of true record locking:
Tools | Options | Advanced | Open databases using record-level locking.

Can't say I'm a fan of that approach though: it does take a performance hit,
and the option broke some code I had which was reasonably involved (merging
two clients and their related records in several tables, some relying on
cascading updates and deletes, within a transaction). As soon as the users
deselected this option, the code worked for them without error, so I never
bothered trying to trace the issue further.