Opening another access database from within an access database

[Guest]

I have a number of unrelated databases that I commonly use. I would like to
create a central form in another database that would allow me to open any
database at the touch of a button. I have tried using the open application
command in a macro but it doesn't work. Any suggestions would be greatly
appreciated

 

[fredg]

I have a number of unrelated databases that I commonly use. I would like to
create a central form in another database that would allow me to open any
database at the touch of a button. I have tried using the open application
command in a macro but it doesn't work. Any suggestions would be greatly
appreciated

Code the Click event of a Command button on that central form:

Application.FollowHyperlink "Path to Folder\DatabaseName.mdb"

 

[Guest]

Try using FollowHyperlink

Dim MyMDB as String
MyMDB = "c:\MdbName.mdb"
Application.FollowHyperlink MyMDB