Running multiple copies of Access

[Luke Bellamy]

Hi,
My Access2002 runtime application links in tables chosen from a source.
If a user opens my application twice and choses a different source then both
the application point to the last source chosen.
Anyone know a way you can test to see if Access 2002 runtime (my app) is
running before it's opened? Note I have a little VB exe that actually fires
up
access 2002 runtime for some pre-processing so can handle a few extra
tricks.

Another solution I thought of is that I can check to see if the core
front-end mde
is being used by the current use and creating a "mirror" copy and the 2nd
session
can use that. But I'd need to be able to check and mde and see if it's in
use.
Is this possible?

Thankyou

 

[Albert D. Kallal]

Perhaps the follwign might work for you:

API: Preventing multiple instances of a database
http://www.mvps.org/access/api/api0041.htm