Microsoft Office Tutorials and References
In Depth Information
Editing with Multiple Users
Records versus pages
Sometimes, Access locks more than just the
record being edited. Like most programs,
Access stores information in chunks called
disk pages or pages. It retrieves information
from your hard drive a page at a time, and it
can lock an entire page’s worth of
information much more easily than it can lock a single
record, which usually is smaller than a page.
(How many records fit in a page depends on
how big each record is. If your table has large
records with lots of fields, a record may even
be larger than a single page of storage.)
Access uses a system called page-level
locking rather than real record-level locking.
Page-locking is faster and easier for Access
than real record-locking, but in some
applications, page-locking just isn’t good enough. If
you have several people entering and editing
orders in an order-entry database at the same
time, they may end up continually locking one
another out of records, which is very annoying.
You can control whether Access does true
record-level locking or just page-level locking.
In the Advanced section of the Client Settings
pane of the Access Options dialog box (refer
to Figure 2-2, earlier in this chapter), check
the Open Databases by Using Record-Level
Locking check box to use record-level locking.
Edited Record (Locks one record)
Our favorite record-locking setting is Edited Record, which locks only the
record that’s being edited. Leave the rest of the records available for other
people to edit.
If you try to edit a record that someone else is editing, Access beeps and
doesn’t allow you to make changes. The international “don’t even think
about it” symbol (a red circle with a diagonal line through it) appears in
the record selector when a record is locked. Within a few seconds after
the other person saves his or her changes, Access displays the changes
onscreen. Then you can make your own changes.
If you use forms to edit your tables (as most people do), you can control
how each form locks records when someone uses the form to edit a record.
Open the form in Design view by right-clicking the form in the Navigation Pane
and choosing Design View from the contextual menu. Display the Properties
sheet for the form by clicking the Property Sheet button in the Tools group
on the Design tab of the Ribbon. Click the Data tab on the property sheet,
and look at the Record Locks property of the form. You can set it to No
Locks, All Records, or Edited Record.