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

 

[Arvin Meyer]

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 use it
with the API as in:

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

 

[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.

 

[Arvin Meyer]

I got the same result. I guess you cannot use a macro to start another
instance of Access. I never to use macros anyway so I'll have to suggest
that you copy the code from:

http://www.mvps.org/access/api/api0018.htm

into a standard module, and save the module with a name like basUtilities
(anything but the function name) then call it from a command button like:

Sub cmdWhatever_Click()
Dim x
x = fHandleFile("C:\Your Path To\YourFile.mdb", WIN_NORMAL)
End Sub
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access
Co-author: "Access 2010 Solutions", published by Wiley

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.