Specify the default record-locking strategy used in a multiuser environment in an Access database

1. On the Tools menu, click Options.
   
   
2. Click the Advanced tab.
   
   
3. In the Default Record Locking box, click the option you want.

   For information on these options, click .