Have 2 Databasese Open

[bmoler]

I would like to beable to have a database open and click a button and have another database open in a seperate Access window. Is this possible? and if so, is their coding involved?
I know there is an open databse command but when I do that it trys to open the other database in the same window. I need both to be open simultaneously. This way I can work in both.

Please Advise...

 

[dhookom]

You should be able to use Shell()
Dim RetVal
RetVal = Shell("MSAccess.exe C:\ParseText.mdb", 1)
End Sub


Duane
MS Access MVP
Find out how to get great answers faq219-2884.