Solved Open External Access Database

[RevJeff]

Is there a way of opening a second database using VBA from within the first database?

Thanks

 

[June7]

Yes. Do you want to open it and let user have control or do you want code to do something with the db then close it?

 

[RevJeff]

Yes. Do you want to open it and let user have control or do you want code to do something with the db then close it?

Just open it and let the user have control.

 

[June7]

You want either FollowHyperlink or Shell. Review and pick one https://www.devhut.net/2018/01/21/ms-access-vba-open-another-database/

 

[Isaac]

Also to open the database using a new Access instance:

dim AccessApp as Access.Application
set AccessApp = createobject("Access.Application")
AccessApp.OpenCurrentDatabase "path to access database file"