Heenan, Lambert
Lambert.Heenan at chartisinsurance.com
Tue Mar 27 08:44:14 CDT 2012
Bill, I have such a beast that I put together a while ago. It's an Access 2003 app that handles queries, forms, reports, modules, and macros. Let me know where I should send it. Lambert -----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 10:00 PM To: Access Developers discussion and problem solving Subject: Re: [AccessD] database prevented from being opened or locked 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