Share via

Ways to avoid data-locking conflicts in an Access database in a multiuser environment

  • Article

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

There are four settings that help you avoid data-locking conflicts with other users in a Microsoft Access database in a multiuser environment:

  • Refresh Interval (sec) sets the number of seconds after which Microsoft Access automatically updates records in Datasheet or Form view. Valid values are 0 through 32,766 seconds. When you refresh the current datasheet or form, Microsoft Access doesn't reorder records, add new records, or remove deleted records. To view these changes, you must requery the underlying records for the datasheet or form.

  • Update Retry Interval (msec) sets the number of milliseconds after which Microsoft Access automatically tries to save a changed record that is locked by another user. Valid values are 0 through 1,000 milliseconds.

  • Number of Update Retries sets the number of times Microsoft Access tries to save a changed record that is locked by another user. Valid values are 0 through 10.

  • ODBC Refresh Interval (sec) sets the interval after which Microsoft Access automatically refreshes records that you're accessing using ODBC. Valid values are 1 through 32,766 seconds.

For information on specifying one of these options, click aa218870(v=office.10).md.