Charlotte Foust
cfoust at infostatsystems.com
Fri May 2 10:14:33 CDT 2003
Take a look at the OpenCurrentDatabase method. Both databases stay open but you switch to the new one. Charlotte Foust -----Original Message----- From: Jeanine [mailto:jscott at mchsi.com] Sent: Friday, May 02, 2003 4:30 AM To: accessd at databaseadvisors.com Subject: [AccessD] Close current database I am running into some problems with something and I think I may just be making it too hard. I want to open one database from another - close the first and run some code in the second. Then close the second and open the first again. I have messed around with the open and close currentdb methods but they only seem to be for the purpose of automation. My objective is to check the current version when my users open their application. If the version is not current the routine will close the application and open a separate db that does the copy routine. Then the copy db will close itself and re-open the application. My theory is this will give the users a pretty seamless version control system. I just can't get the darn thing to close itself and open another db. Thanks! _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com