Launch a new mdb from another mdb

[David C]

I have a tracking database in MSAccess which runs nicely.

Now I wish to launch this from within another MSAccess database in response
to a button click (using VBA, I guess).
- ideally, the first db would close itself after opening the tracker
- I experimentated with various code, best was Application.FollowHyperlink
("filename"), but I am not sure how stable the thing is, or what problems
this might create.
- Should this come before or after DoCmd.Close ?

 

[Klatuu]

You can use either the Shell command or the FollowHyperLink or the
ShellExecute (Code can be found at this site:
http://www.mvps.org/access/api/api0018.htm)
to launch your other application.
First launch the other app, then Docmd.Quit