Home  |  About  |   Search   

What's New
Table Of Contents
Credits
Netiquette
10 Commandments 
Bugs
Tables
Queries
Forms
Reports
Modules
APIs
Strings
Date/Time
General
Downloads
Resources
Search
Feedback
mvps.org

RunCommand Constants

Terms of Use


 

Modules: Opening another database in the same instance

Author(s)
Dev Ashish

If you have multiple databases in your application, you may need to switch to a different mdb file at times.  The most often recommended method is to Shell out to the new database in another instance of Access and then Quit the current instance from code.  Depending on the machine and amount of available resources, you may want to reuse the same Access instance for other databases.

Access 2000 & Access 97:

Michael Kaplan has made available a COM Addin that allows you to shut down an Access database and optionally open another one.  No Access 2000 application should have to use Sendkeys statement, ever again! (IMO).

TSI SOON (Shut One, Open New) Addin

Prior versions:

The only solution is to use SendKeys to pass the new database path to the OpenFile dialog.  Beware of the associated bug and the fact that any sensible VBA developer will tell you not to use SendKeys in any application.

'************ Code Start **********
Sub sOpenMDB(strInMDB As String)
    On Error Resume Next
    SendKeys "%FO" & strInMDB & "~"
End Sub
'************ Code End **********

1998-2009, Dev Ashish & Arvin Meyer, All rights reserved. Optimized for Microsoft Internet Explorer