Understanding Access's Locking Mechanisms
Although the preceding tips for designing network applications reduce network traffic, they in no way reduce locking conflicts. To protect shared data, Access locks either a record or a page of data as the user edits a record. In this way, multiple users can read the data, but only one user can make changes to it. You can lock data through a form or through a recordset that isn't bound to a form.
Here are the methods of locking for an Access application:
Record locking
Page locking
Table and recordset locking
Opening an entire database with Exclusive access
With record locking, Access locks only the record that the user is editing. With page locking, Access locks only the 4K page with the edited record. ...
Get Alison Balter's Mastering Access 2002 Enterprise Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
