[AccessD] database prevented from being opened or locked

Bill,

I used to have code to do something like this but it used ADO, not DAO, and
It's MIA for now.  Sorry.

Charlotte Foust

On Mon, Mar 26, 2012 at 6:59 PM, Benson, William (GE Global Research,
consultant) <Benson at ge.com> wrote:

> Hey Dan,
>
> Well, I did try it every which way (as my earlier post said, I tried it
> both with and without Shift held.
>
> One thing I am wondering now is if someone has a slick bit of code for
> listing all objects in a database of their choice (ie, not opened, but read
> say, from disk) and a listbox with similar target database candidates...
> and the command button they have coded does a swap and replace WITHOUT
> sequencing the object, which is Access's inherent/default  behavior when
> one uses the interface (a "feature" which I absolutely hate, though I
> recognize its place in the universe).
>
> I would really like to go "Put This in That - GO!".
>
> I am going to write it myself if no one has it handy.
>
> I would really like to have a dashboard of database maintenance devices
> like that which do not rely on the interface.
>
> Bill
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters
> Sent: Monday, March 26, 2012 9:10 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] database prevented from being opened or locked
>
> 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
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>