View Single Post
  #2  
Old July 6th, 2004, 01:18 AM
Raghu Prakash
external usenet poster
 
Posts: n/a
Default You do not have exclusive access... ERROR

Hi Robin,

SYMPTOMS
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:

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.
This error message occurs even if there is only one user in the database.
CAUSE
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.
WORKAROUND
To work around this problem, use one of the following methods:
Rename the database file to make sure that only one .ldb file is in the
folder that contains the database file and the workgroup information file.
Move the database file to another folder.
Open the database exclusively.
MORE INFORMATION
Steps to reproduce the problem
Create a new workgroup information file for your Microsoft Access 2000
database
To do this, follow these steps:
Click Start, and then click Run.
In the Run dialog box, type Full path of Wrkgadm.exe in the Open box.

Note By default, the Wrkgadm.exe file is located in the C:\Program
Files\Microsoft Office\Office\1033 folder.
In the Workgroup Administrator dialog box, click Create.
In the Workgroup Owner Information dialog box, type Northwind in the Name
box, and then type 5 in the Workgroup ID box.
Click OK.
In the Workgroup Information File dialog box, type the location that you
want to save the file to, and then click OK.
In the Confirm Workgroup Information dialog box, click OK.
In the Workgroup Administrator dialog box, click OK.
Create a new workgroup information file for your Microsoft Access 2002
database and for your Microsoft Office Access 2003 database
To do this, follow these steps:
Start Access 2002 or Access 2003.
Open the Northwind.mdb sample database.
On the Tools menu, point to Security, and then click Workgroup
Administrator.
In the Workgroup Administrator dialog box, click Create.
In the Workgroup Owner Information dialog box, type Northwind in the Name
box, and then type 5 in the Workgroup ID box.
Click OK.
In the Workgroup Information File dialog box, type the folder location of
the database file. In the Workgroup box, type the file name Northwind.mdw,
and then click OK.

Note Make sure that the Workgroup Information file has the same file name
and the same folder location as the database file.
In the Confirm Workgroup Information dialog box, click OK.
Close Access 2002 or Access 2003.
Join the newly-created workgroup information file that you created in steps
1 through 8.
Start Access 2002 or Access 2003.
Open the Northwind.mdb sample database.
Open an Access database object, such as a form, a report, a macro, or a
module.

You may receive the error message that is mentioned in the "Symptoms"
section.
When you open an Access database, if both the database file (.mdb) and the
workgroup information file (.mdw) have the same name, a record-locking
information file (.ldb) is created for the .mdw file and an entry that
indicates that the database file is open is added to the .ldb file. After
the .mdb file is opened, Access detects an .ldb file with the same name as
the .mdb file in the same folder, and therefore adds another entry to the
.ldb file. The entries in the .ldb file now indicate that there are two
users in the database. Therefore, when you open a database object, such as
a report in Design view, Access may detect two active connections in the
.ldb file. This may cause the error message that is mentioned in the
"Symptoms" section. This error message indicates that the user does not
have exclusive access to the database.

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 Further Information : Microsoft Knowledge Base Article - 839782

Please let me know has this helped You...
Thank you...
Raghu...
This posting is provided "AS IS" with no warranties, and confers no rights.