Using Page Locking

This level of locking causes only the page containing the record currently being edited to be locked. Microsoft Jet accesses and locks data in pages of 2048 bytes. When you use page locking, other users can read data from the locked page, but cannot change it. Page locking is the default locking level for Recordset objects. In the parts of your application that lock data at the page level, you must determine which locking mode you’re going to use. The locking mode determines how Microsoft Jet actually locks the data. Two modes of page locking are available: pessimistic locking and optimistic locking.