Alison Balter's Mastering Access 2002 Enterprise Development

Recordset Locking

Recordset locking locks pages of data found in a recordset. By using recordset locking, you can control when and for how long Access locks the data. This is different from locking data through bound forms, which gives you little control over the specifics of the locking process.

When you're traversing through a recordset, editing and updating data, locking occurs regardless of whether you intervene, so you must understand when the locking occurs and whether you need to step in to intercept the default behavior. If you do nothing, Access locks a record, or possibly an entire page of records, each time you begin editing data from your VBA code. This page level lock is 4096 bytes (4K) and surrounds the record being edited. If Access ...