[AccessD] No Exclusive Access to Make Changes

Wortz, Charles CWortz at tea.state.tx.us
Fri Jun 6 09:43:38 CDT 2003


Vlad,

Check to see if the .ldb file still exists.  You probably did an
abnormal exit for the app at that time and left the .ldb open.  Whenever
you use the Task Manager to kill the app, it leaves the .ldb open.

Charles Wortz 
Software Development Division 
Texas Education Agency 
1701 N. Congress Ave 
Austin, TX 78701-1494 
512-463-9493 
CWortz at tea.state.tx.us 
-----Original Message-----
From: ACTEBS [mailto:actebs at actebs.com.au] 
Sent: Friday 2003 Jun 06 09:14
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] No Exclusive Access to Make Changes

 
 Charles,

But this doesn't explain why I am getting this error as I am the only
person with the app open. That's why I can't understand where this is
coming from. I wasn't aware of this change in A2K or greater, and that
is good to know, it's just that this only just started to happen. I was
working on the app yesterday and this wasn't the case then. Hmmm, I hate
these random features!!!

Thanks
Vlad
-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Wortz,
Charles
Sent: Friday, 6 June 2003 10:38 PM
To: accessd at databaseadvisors.com
Subject: RE: [AccessD] No Exclusive Access to Make Changes

Vlad,

Starting with A2K, you have to open Access dbs in Exclusive Mode to do
any design changes.  When you double-click on an A2K or higher db you
are opening it in Shared Mode unless you saved it to open as Exclusive
Mode.  One of the ways to open it in Exclusive Mode to do design changes
is to hold down the Shift key while opening to bypass the normal startup
procedure.
Charles Wortz 
-----Original Message-----
From: ACTEBS [mailto:actebs at actebs.com.au] 
Sent: Friday 2003 Jun 06 00:22
To: access group
Subject: [AccessD] No Exclusive Access to Make Changes
Importance: Low


Hi People,

I am mucking around with a totally unbound FE (AXP) app and have started
to get this error when I try to go into the design of any form:

"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 I close the database and re-open it hold the Shift Key to display the
DB window - No Problems all is OK. As soon as I run the app and then go
to make some design changes the above dialogue box appears.

Have I not closed a recordset or what is going on here. Anybody had this
happen and figured out the problem...

Thanks in advance

Vlad


More information about the AccessD mailing list