Open a Database with VBA

[graviz]

What is the easiest way to open another database with VBA and close the current one you are in. I've tried a couple ideas and when it does it, it closes right away. Any ideas?

Dim accapp As Access.Application
Set accapp = New Access.Application
accapp.OpenCurrentDatabase ("c:\blah.mdb")
accapp.Visible = True

 

[HiTechCoach]

I find it works well if you use this:


Start an app with ShellExecute


I use it to open another database just like what you want to do.