Locking Database Records

In a multi- user environment, several users could attempt to edit the same record simultaneously . Access prevents conflicts of this sort using record locking , ensuring that only one user at a time can edit data. You can also prevent conflicts by opening the database in exclusive mode , preventing all other users from accessing the database while you're using it. This technique is useful for administrators who need sole access to the system while making changes to the database itself.

Set Record Locking


Click the Tools menu, and then click Options.


Click the Advanced tab.


Indicate whether the default strategy for opening the database is shared (allowing simultaneous access by other users) or exclusive (keeping out other users).


Click the Default Record Locking strategy option you want to use.


Verify that the Open Databases Using Record-Level Locking check box is selected.


Click OK.


Record Locking Strategies

Locking Type


No Locks

Access does not lock the record you're editing. When you save changes, Access gives you the option to overwrite another user's changes, copy your version to the clipboard, or discard your changes.

All Records

Access locks all records in the table for the entire time you have it open, so no one else can edit or lock the records.

Edited Record

Access locks the record you're currently editing and displays a locked record indicator to other users who may try to edit the record.

Show Me Microsoft Office Access 2003
Show Me Microsoft Office Access 2003
ISBN: 0789730049
EAN: 2147483647
Year: 2002
Pages: 318

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net