Microsoft KB Archive Search

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.

  1. Home
  2. ACC2000: "You do not have exclusive access..." Message Appears More Than Once When Editing Module

ACC2000: "You do not have exclusive access..." Message Appears More Than Once When Editing Module

View products that this article applies to.

This article was previously published under Q225938
Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).

For a Microsoft Access 2002 version of this article, see 293613� (http://support.microsoft.com/kb/293613/EN-US/ ) .

↑ Back to the top

Symptoms

When you try to edit code in a module, you may see the following message, even though you just saw the same message:
You do not have exclusive access to the database at this time. If you proceed to make changes, you may not be able to save them later.

↑ Back to the top

Cause

You see this message more than once when you are in a multiuser environment, and you perform either of the following actions:

  • You insert a new module, and then edit any module.
    -or-
    You edit a form or a report class module.

↑ Back to the top

Resolution

Click OK to close the second occurrence of the message. You can then make the changes to the code; however, you may not be able to save the changes that you make.

↑ Back to the top

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

↑ Back to the top

More information

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. Open a second instance of Northwind.mdb.
  3. In the Database window, click Modules under Objects, and then click New. Note that you receive the message mentioned in the "Symptoms" section.
  4. Click OK.
  5. Open the Form_Employees class module.
  6. When the Code window appears, make any change to the module. Note that the same message appears a second time.
  7. Click OK. Note that the message appears a third time.

↑ Back to the top

References

For additional information about exclusive locks, please see the following article in the Microsoft Knowledge Base:
200290� Need Exclusive Lock to Save Design Changes to Objects

↑ Back to the top

Keywords: KB225938, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 225938
Revision : 2
Created on : 6/29/2004
Published on : 6/29/2004
Exists online : False
Views : 338