Specify the locking level used in an Access database in a multiuser environment

1. On the Tools menu, click Options.
   
   
2. Click the Advanced tab.
   
   
3. To make record-level locking the new default setting for the current Microsoft Access database, 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.

Notes

• This setting takes place 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. This behavior is the same as the setting for the default open mode.
  
  
• If you select Open databases using record level locking, this becomes the default behavior for access to data through a form, a datasheet, and code that uses a recordset object to loop through records, but not through action queries, nor through code that performs bulk operations using SQL statements. For more information, see Chapter 16, "Multiuser Database Applications," in the Microsoft Office 2000/Visual Basic Programmer's Guide.