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

Chapter 12. Managing a Database > Locking Database Records

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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