Link to home
Create AccountLog in
Avatar of SweetingA
SweetingA

asked on

Open one access database from another

I am trying to open several access databases from command buttons in a single database.
I have tried using FollowHyperlink and tying the path in teh run command of a macro but neither work.
I have read in several places that the macro action RunApp works but RunApp is not listed on my action list.
Is there a simple method?

ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of SweetingA
SweetingA

ASKER

perfect, thankyou
Try this that opens database, D:\Words.mdb from a command btton in a form in another database.

Private Sub Command12_Click()
    Dim app As Application
    Set app = CreateObject("Access.Application")
    app.OpenCurrentDatabase ("D:\Words.mdb")
    app.Visible = True
End Sub