Microsoft KB Archive/293613

= You may receive a &quot;You do not have exclusive access to the database at this time&quot; error message when you edit a module in Access 2002 =

Article ID: 293613

Article Last Modified on 8/19/2004

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q293613



Moderate: Requires basic macro, coding, and interoperability skills.

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



For a Microsoft Access 2003 version of this article, see 839782.

For a Microsoft Access 2000 version of this article, see 225938.



SYMPTOMS
When you try to edit code in a module, you may receive 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.



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.



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.



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



Steps to Reproduce the 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 that is mentioned in the &quot;Symptoms&quot; section of this article.
 * 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.

