Any Way to Run Access Function in Separate Process?

[Will]

We have a modal dialog in an Access application, that upon confirmation goes
out and does about 25 minutes of queries and then puts the result on the
clipboard. This long processing period locks the user out from the rest
of the application. We want to find a way to have this 25 minutes of data
gathering run in the background without blocking the user from interacting
with other parts of the application.

Is there any way to launch the function that takes so long to run in a
separate process space, so that it doesn't lock up the application while it
runs? We would obviously need the new process to inherit the context of
the parent process. What other options are there?

 

[Albert D. Kallal]

put the function and code in a new separate mdb, and launch that
separately......

You can't launch a new thread in access, but you can certainly launch
another copy of ms-access to run a separate new mdb.....