• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 22. HANDLING MULTIUSER SITUATION... > LOOKING AT THE BUILT-IN LOCKING MODE...

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



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint