open a database from another database

[pat67]

I wan to open other databases from a macro in one database. I can't
seem to find the command. Can someone help?

Thanks

 

[pat67]

From a macro, you would use the RunApp action and put in the full path to
your database as an argument.

In VBA code the best choice is to use the Shell function. I prefer to useit
with the API as in:

http://www.mvps.org/access/api/api0018.htm
--
Arvin Meyer, MCP, MVPhttp://www.datastrat.comhttp://www.accessmvp.comhttp://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley







- Show quoted text -

Thanks. I will try one of those.

 

[pat67]

Thanks. I will try one of those.- Hide quoted text -

- Show quoted text -

In the command line what do i need to put besides the path? Entering
just the path did not work. I get an error saying the path is invalid
or a component is missing. The path is correct because if i copy it to
explorer it opens the database with no problem.