Article ID: 839782 - View products that this article applies to.
Novice: Requires knowledge of the user interface on single-user computers.
This article applies only to a Microsoft Access database (.mdb).
When you open a Microsoft Access database object, such as a form, a report, a macro, or a module in Design view, you may receive the following error message:
This error message occurs even if there is only one user in the database.
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.
If the database file and the workgroup information file have the same name and are located in the same folder, two record-locking information files (.ldb) are created when an Access object is opened. This causes the error message that is mentioned in the "Symptoms" section.
Note By default, the record-locking information file is created with the same file name as the workgroup information file. The record-locking information file is also created in the same folder as the workgroup information file. The record-locking information file has an .ldb file name extension.
To work around this problem, use one of the following methods:
Steps to reproduce the problem
Create a new workgroup information file for your Microsoft Access 2000 databaseTo do this, follow these steps:
Create a new workgroup information file for your Microsoft Access 2002 database and for your Microsoft Office Access 2003 databaseTo do this, follow these steps:
If you open the database, close the database without closing Access, and then you open the database again exclusively, you may be able to view the database object in Design view. When you open the database the first time, the .mdw file is accessed, and therefore the .ldb file is created. Two active-connection entries are written to the .ldb file. One active-connection entry is for the .mdw file, and the other active-connection entry is for the .mdb file. When you close the database, the second active-connection entry in the .ldb file may be removed or may be modified to indicate that the user is no longer connected. Subsequently, when you open the database exclusively, Access may not create an .ldb file or may not write an entry to the .ldb file because Access detects only one active entry in the .ldb file. You can open a report in Design view because Access detects only one user in the database.
For additional information, click the following article numbers to view the articles in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/225938/ )"You do not have exclusive access..." message appears more than once when editing module
(http://support.microsoft.com/kb/200290/ )Exclusive lock required for saving design changes to Access objects
(http://support.microsoft.com/kb/305541/ )Understanding the role of workgroup information files in Access security