Administrator: Receipts (Start) 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40

Prepare to Share

Microsoft Access can be configured for startup, maintenance and security.  Before you share this mighty database, you should review the options.

 

Try it: Edit the Advanced Options

Default open mode: Shared.

Shared allows many users to open the database. Exclusive restricts the database to one user.

 

Default record locking: No locks.

If you lock All Records, then the data cannot be updated, only reviewed.

 

Record-Level Locking

By default, Microsoft Access locks the record someone is editing so that two users cannot change the same record at the same time.

Office ->Access Options->Advanced
 

 

  Microsoft Access 2007 Exam 77-605 Topic: 6. Managing and Maintaining Databases

  6.1. Perform routine database operations    6.1.1.   Open databases: With shared access