Changing Locking in Microsoft Access
From ASU HOWTO
Access 2003
Tools Menu | Options | Advanced
- Default open mode: Shared
- Default record locking: Edited Record
- Open databases using record_level locking
Access 2007
Office button | Access Options | Advanced | Advanced
- Locking: Edited Record