OpenDatabase Method

[Jim Pockmire]

When using the OpenDatabase method to open a 2nd database, is it possible
to open a form in the 2nd database and/or view the 2nd database in the
database window?

 

[Allen Browne]

Try Shell() if you wish to open another instance of msaccess.exe.

 

[Jim Pockmire]

"Shell" was my first solution and I was hoping to find a way to not to open
a 2nd instance of MS-Access. I am also considering setting a reference and
then open a form in the 2nd mdb, but am not sure this will work either.