Share this Page URL

Chapter 18. Maintaining an Access Databa... > Converting an Access Database - Pg. 631

Maintaining an Access Database 631 · Default Open Mode If you want more than one person to be able to open a database at the same time, set this option to Shared. Set this option to Exclusive if you want only one instance of the database to be open at any one time. You'll learn more about database security settings for opening a database inChapter 19. · Default Record Locking When a record is locked for editing by one user, other users are pre- vented from making changes to the same record. The three options in this area of the dialog box specify the type of record locking Access will use. Select No Locks to implement no record locking. Select All Records to lock all the records in a record source (a query, for example, as well as the tables used in the query) when the records are being edited. Select Edited Record to lock the specific record being edited. Clearly, the No Locks option is most optimistic. It as- sumes that you'll never have conflicts when more than one user updates data. The All Records option is useful in situations in which a single user updates a particular record source most of the time. In situations when many users need to work with a particular set of records at the same time--entering orders, for example--the Edited Record option provides more flexibility. · Open Databases Using Record-Level Locking Use this option to specify the default locking level for the current database. Selecting this option applies record-level locking, which locks the re- cord a user is editing. Clearing this option turns on page-level locking. Page-level locking locks the set of records on a disk page. ( A disk page refers to an area of physical disk storage.) For the majority of cases, keep this option selected. You might also want to adjust settings on the Advanced tab for the Refresh Interval and Number Of Update Retries properties. These properties specify how often Access will try to save a record that is locked by another user. The default values are fine in most cases. Converting an Access Database