Close database but leave access open
Quote:
>Is there a way to close a database, but leave Access open (in VB).
>What would be ideal is if I could close the database, then have the
>window popup asking for which database you would like to open, like
>when you first open MS Access.
>Any help would be greatly appreciated.
>-Chris
If you have not denied access to the database window by turning off
the Use Special Keys property in Startup, You could use
SendKeys "{F11}"
DoCmd.Close
This will close the current db but leave Access open.
However if you then want to open another database, you would need to
select the db you want to open BEFORE you close the current file. You
could then use Michael Kaplan's TsiSOON utility (shut one open next)
to close the current file and open the selected database.
You can get the utility from his website www.trigeminal.com
Wayne
