I have two databases named, say, DB1 and DB2. Other than the name, they are identical. On occasion, a user will run a report that takes a very long time to run. The operator may enter the report parameters and request the report to run "in the background". After editing the input and just before starting the Report, I launch a separate instance of Access for the "other" database using VBA. (If I'm running DB1, I launch DB2. If I'm running DB2, I launch DB1.) All this is working fine as long as the database I try to launch isn't still running from a previous launch. If this is the case, then the launch request is simply ignored. Is there a way I can interrogate Windows to see how many Access processes are already running for this user. It would be similar to opening Task Manager and, in the Processes tab, count how many times ms access appears for a given user.



Thanks, Eddie