Opening another instance of Access with VBA
Hello. I was asked a question that I have never thought of before.
How can an Access application open another one? Please do not misunderstand me here. I am not talking about using the OpenDatabase method. It would be more like closing the current Access app and open another one.
My customer has two separate databases and they are 'kind of' related. So from one form there would be a command button launching the other one.
From the other one I could verify if the app is open then close it.
Would it be similar to opening Word or Excel with a specified document?
Set objAcc = CreateObject("Access.Something")
.Application.Visible = True
Shell "Access.exe", vbHide
I am not sure where to start with this. Any idea anyone please?