Importing multiple objects between MDBs efficiently
Somehow, and I have no idea how, I figured out that you can drag and drop objects from one Access MDB to another. Open the donor database and maximize the database container window. But resize the database so it only takes up three quarters of the Windows desktop. I always put this in the upper left hand corner.
Open the target Access MDB, maximize the database container window, and make it smaller than the Windows desktop. I always put this in the lower right hand corner. I always put the databases in the same place so I don't get confused.
Click on the donor database and ensure you can still see a small bit of the target database container window. Now drag and drop to your hearts content.
Of course, if I'm doing multiple objects I will switch to the details window in the donor database and sort the objects by date in ascending sequence. This doesn't work for modules however as MS changes all the modules data and times to be the same. If I want to see if the object is already in the target database I go to the target database, click in the window and hit the first letter of the object name to roughly go to that object in the list.
