Starting, Running, and Stopping One Access App from Another

[Mike Thomas]

In an Access 2000's application's VBA module, I would like to be able to
start, on the same computer (eg Access is already running), another Access
application, run a procedure in one of the code modules, shut itself down,
then return to the next line of execution in the calling module of the
original Access application.

Does anyone know how this would be done?

Many Thanks
Mike Thomas

 

[Steve]

Try this.

In the first database, enter the code below to open the
second database.

Dim db2 As Object
Set db2 = GetObject("*** Second Database's Path/Name***")
db2.Quit

Then in the second database, create a Macro (eugh!) called
Autoexec and add a RunCode row. Enter the name of the
procedure you want to call, including the Parenthesis,
e.g. Procedure_Name()

And that, my friend, should be the answer! (or maybe a
partial answer anyway

Good Luck,
Steve.