O'Reilly logo

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

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required