avoid open an opend application

[Sam]

how can i avoid user to open an application that is
already opend?

thanks

 

[Rick B]

Not sure what you are asking. Are you building a button on a form to open
an application and you want to jump to the active one if there is already an
instance of the application? You are using MS Access, right?

 

[Albert D.Kallal]

If it is single user, then you can set the open command to "exclusvie", and
that will do the trick.

If you got multi-userk, then you like best check if it is running already.

Ther is a api here that can help you:

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

 

[Sam]

is their is a way to do the job when user clik's the shortcut on desktop?

 

[Albert D.Kallal]

You would have to use that api code, and in your startup, check if the
appcation is running, and then quit.....

So, in effect, a 2nd copy would try and run...but you would not let it get
very far.....