[AccessD] database prevented from being opened or locked

Dan Waters df.waters at comcast.net
Mon Mar 26 20:09:56 CDT 2012


Hi William,

If one of your databases has a startup form or an AutoExec macro, copying
objects may get you that error message.  Sure does for me.

Try holding down the shift key to bypass the startup form or AutoExec macro.
Don't open anything in either database.  Then try to drag/drop objects from
one to the other.  Should work.

Dan

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Benson, William
(GE Global Research, consultant)
Sent: Monday, March 26, 2012 7:29 PM
To: Access Developers discussion and problem solving
Subject: [AccessD] database prevented from being opened or locked

I would like to drag and drop objects from one opened Access database to
another. Visually this looks like it ought to be possible, however in
practice it never seems to work. No matter whether I open the target
database in the Access Open dialog either with
	Open
	Open Exclusive
	Open in Microsoft Access

I always get the message about the database has been placed in a state which
prevents it from being opened or locked.

I also have tried it all 3 ways with or without Shift held, and that makes
no difference to this attempted (and failed) operation.

I am the only user of the database:  is there a way to be able to perform
these kind of steps without using VBA or Export/Import using an unopened
database? 


-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list