VBA, How to open another database from within Access using code

How to open another database from within Access using code

Author	Message
jjr.rei #1 / 2	How to open another database from within Access using code This seems easy but so far I can not get it to work. How can you get Access to open another database using code. I have tried send keys "^O~" for file open and selecting the database file, but nothing happens. If I try application.opencurrentdatabase, this will open another file, but will leave the original file open, which if you then close will close both Access files. This seems really easy but I must be missing something !!!
Tue, 25 Nov 2003 17:41:48 GMT

TSP #2 / 2	How to open another database from within Access using code Hi, Try Call Shell(strAppPath, 1) DoCmd.Quit Works well in Access 97! Chris Quote: > This seems easy but so far I can not get it to work. > How can you get Access to open another database using code. I have tried > send keys "^O~" for file open and selecting the database file, but nothing > happens. If I try application.opencurrentdatabase, this will open another > file, but will leave the original file open, which if you then close will > close both Access files. > This seems really easy but I must be missing something !!!
Wed, 26 Nov 2003 07:03:27 GMT

Page 1 of 1

[ 2 post ]