Opening another access database from within an access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...

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

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

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