[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 
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 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
 
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030606/cdb392ec/attachment-0001.html>