Open another Access Application from Access

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to open another instance of Access using VBA behind a button. I
have tried both methods I found in the Help files. I seem to open the
database (the lock file appears in Windows Explorer) but I don't have another
instance of Access open on the screen and I get an error when I try to open a
form in the other database.

Thanks for any suggestions,
Jim
 
I am trying to open another instance of Access using VBA behind a button. I
have tried both methods I found in the Help files. I seem to open the
database (the lock file appears in Windows Explorer) but I don't have another
instance of Access open on the screen and I get an error when I try to open a
form in the other database.

Thanks for any suggestions,
Jim
Click to expand...

I have no idea what method you are using, however this works for me:

Application.FollowHyperlink "c:\MyFolderName\MyDbName.mdb"
 
Back
Top