Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

"You do not have exclusive access to the database" error in Access


View products that this article applies to.

Symptoms

When multiple users share a single Microsoft Access database, and you try to open a specific form or report object, you receive the following error message:

You do not have exclusive access to the database at this time.

↑ Back to the top


Cause

The following combination of settings and conditions triggers an object update: 
  • Multiple users have the same database file open.
  • The Compact On Close database setting is selected.
  • The Track name AutoCorrect info and Perform name AutoCorrect database settings are both selected.
  • The form or report object you’re trying to open contains an embedded macro within a control or form event.

In this situation, Access tries to save the changes but cannot gain exclusive access to the object.

↑ Back to the top


Resolution

To prevent this error, do one of the following:
  • Use the split database approach so that each user has a local copy of the front-end database. For more information, see Split an Access database.
  • Clear the Compact On Close check box at File -> Options -> Current Database –> Application Options.
  • Clear the Perform Name AutoCorrect check box at File -> Options -> Current Database -> Name AutoCorrect Options.
  • Remove embedded macros from the form, or report and replace them with either named macros or VBA event procedures.

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 3207256
Revision : 7
Created on : 8/20/2020
Published on : 8/20/2020
Exists online : False
Views : 66