Hello Kathy,
Reg. your query , i think its not possible, atleast until now to do
that. Even in Access 2003 its the same problem, when you want to open another
database, and leave the current database open, it doesn't work. That what, i
know, atleast until now.
Sure it can work.
But you need to create a new Instance of MS Access
Public Function newMSAccess(strPathtoAccess As String)
Dim objMSAccess As New Access.Application
With objMSAccess
.OpenAccessProject strPathtoAccess, False
End With
End Function