How to open an database fom code

[knupett]

How can I open an other database(in the database windows) from code and at the same time close the database where I am opening from. I try the “sendkeys” but run into trouble with different language and the runtime access
I make a dos batch file but it look a little primitive.
Any good suggestion??

knupett

 

[Keith P]

The following should work
Dim hypAdd as string
hypAdd= "C:\MyFolder\MyDb.mdb"
Application.FollowHyperlink hypAdd
Docmd.Quit