Menu issue

[danielcan]

Good day again

In my main switchboard I want to put a macro to close a database to open another one. what would be an appropriate code or macro format to use.

Thank you

 

[jsteph]

Use Code, not macros:

Sub OpenDB()
Dim aC As Access.Application

Set aC = New Access.Application
'Open the other db
aC.OpenCurrentDatabase "C:\SomeFolder\SomeDatabase.mdb"
'close this one
Quit
End Sub

--Jim