Changing Locking in Microsoft Access

From ASU HOWTO
Jump to: navigation, search

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