Starting an Access app from another Access app.

[Pat]

I need to start an Access app from an Access app.
Is the shell command the way to go? or is there another preferred method?

[HansV]

If you only need to open a database in another instance of Access, you can use Shell.
If you want to manipulate the database in code, you can use Automation:

Dim app As Access.Application
Set app = CreateObject("Access.Application")
app.OpenCurrentDatabase "C:\Databases\MyDatabase.mdb"
...
app.DoCmd.OpenQuery "MyQuery"
...
app.Quit
Set app = Nothing

[Pat]

No i just have to start the access app.
Good to know the other approach though.
Thank you