A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

You do not have exclusive access... ERROR



 
 
Thread Tools Display Modes
  #1  
Old June 30th, 2004, 07:04 PM
Robin
external usenet poster
 
Posts: n/a
Default You do not have exclusive access... ERROR

I am having the same trouble that I see many others have had:

“You do not have exclusive access to the database at this time. Your design changes will not be saved.”

I can't seem to get it to leave me alone!! What else can I do??

I am the only one who works in Design Mode on this database, so I don’t make changes when others try to use it. They only enter and update data in forms and run the occasional report.

Because of our network, no one is able to save anything on the hard drives – so splitting the database will not really make anything quicker.

I have tried changing the settings to “Advanced” setting to” Shared” and “No Locks”.

I have given full permissions to my group of users for the file and the folder because of the “Access.LockFile.9”.

I have checked that the “Record Locks” property in the forms and reports are set to “No Locks”.

Still, I get this error message. Can anyone help me keep my sanity???? PLEASE!!


or


Ads
  #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.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Access XP Run-time error -2147024769 (8007007F) Doug New Users 3 April 11th, 2005 07:05 PM
Ms Access VB Error Debbie General Discussion 6 July 2nd, 2004 01:25 PM
Access 2003 RK General Discussion 12 June 14th, 2004 10:16 AM
Name? error in Access 97 Using Forms 1 June 3rd, 2004 05:01 PM
Productkey problem when installing office 2003 on network Stefan Schreurs Setup, Installing & Configuration 1 June 1st, 2004 11:16 PM


All times are GMT +1. The time now is 05:37 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.