Microsoft Office Tutorials and References
In Depth Information
Editing with Multiple Users
4. Click OK.
5. Close the database and then reopen it.
Access opens the database in shared mode.
Everyone can look at the information in the database. But what happens when
two people want to edit a table at the same time — or, worse, two people
want to edit the same record at the same time? The Access record-locking
feature handles this situation.
To turn on the record-locking feature, click the File tab of the Ribbon, choose
Options, select Client Settings, scroll down to the Advanced section, and
look at the Default Record Locking section (refer to Figure 2-2, earlier in this
chapter). You have three options: No Locks, All Records, and Edited Record.
The following sections detail how these options work.
No Locks (Doesn’t lock records)
Multiuser editing works as follows without record-locking (when you check
the No Locks check box in the Access Options dialog box):
1. Person A opens a table or query (or a form based on a table or query)
and begins editing a record.