Set options for a shared Access database (MDB)

 Note   The information in this topic applies only to a Microsoft Access database (.mdb).

  1. On the Tools menu, click Options.
  2. Click the Advanced tab.
  3. Do one or more of the following:

ShowSpecify whether a Microsoft Access database opens in shared or exclusive mode by default

  • Under Default open mode, do one of the following:

If you want others to be able to open the Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.) at the same time you have it open, click Shared.

If you want sole access to the Access database when you have it open, click Exclusive.

Notes

ShowSpecify update retry and refresh interval settings

  • Do one or more of the following:

To set the interval after which Microsoft Access automatically tries to save a changed record that is locked by another user, type the number of milliseconds in the Update retry interval box. Valid values are 0 through 1,000.

To set the number of times Microsoft Access tries to save a changed record that is locked by another user, type a number in the Number of update retries box. Valid values are 0 through 10.

To set the interval after which Microsoft Access automatically refreshes records that you're accessing using ODBC (Open Database Connectivity (ODBC): A standard method of sharing data between databases and programs. ODBC drivers use the standard Structured Query Language (SQL) to gain access to external data.), type the number of seconds in the ODBC refresh interval box. Valid values are 1 through 32,766.

To specify how often data is automatically updated, type the number of seconds in the Refresh interval box. Valid values are 1 through 32,766 seconds. For example, if you type 120, the data is updated every 2 minutes. This setting takes effect only if the database is shared on a network.

ShowSpecify the record locking strategy

When a user edits a record, Microsoft Access can automatically prevent others from changing that record until the user has finished editing it. Giving one user exclusive access to a record is called locking.

  • Under Default record locking, do one of the following:

To prevent locking of records while you edit them, click No locks.

To lock all records in the form or datasheet (and the underlying tables) while you edit them, click All records.

To lock only the record you're editing, click Edited record.

ShowSpecify record-level or page-level locking

  • Do one of the following:

To make record-level locking the new default setting for the current Microsoft Access database (Microsoft Access database: A collection of data and objects (such as tables, queries, or forms) that is related to a particular topic or purpose.), select the Open databases using record-level locking check box.

To make page-level locking the new default setting for the current Access database, clear the Open databases using record-level locking check box.

This setting takes effect the next time you open the Access database, but you must use the Open command on the File menu rather than the list of most recently used files at the end of the File menu.

 
 
Applies to:
Access 2003