F. Scott Barker's Microsoft® Access 2000 Power Programming

LOOKING AT THE BUILT-IN LOCKING MODES

Access provides three alternative locking modes that you can use on forms, reports, and queries: No Locks, All Records, and Edited Record. Table 22.2 shows the objects and which modes work with them. You can set these choices globally by accessing the Options dialog (from the Tools menu, choose Options) and clicking the Advanced tab. For more information about this option, see the earlier section “Default Record Locking.”

Table 22.2. Access Objects and Their Possible Locking Settings

Object Type	Locking Modes Used
Form	No Locks All Records Edited Record
Report	No Locks All Records
Query	No Locks All Records Edited Record

Using Record Versus Page-Level Locking

Before Access 2000 (Jet 4.0), Jet didn't use row-level ...