By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,560 Members | 949 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,560 IT Pros & Developers. It's quick & easy.

How to know if instance is already running

P: n/a
In Access 2000, Win NT, Citrix, we have each user opening the front end mdb
in their own folder, and linnking to the back end. I've noticed that a user
can get more than one instance open at a time if they are not careful.

Is there a way to have an instance of Access check to see whether there is
another one already open for this user, and if so, simply to maximize the
window of the already running instance?

Thanks
Mike Thomas
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
I don't know if this will work in Terminal Services or Citrix, but here is
an example you can try.

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

--
Wayne Morgan
Microsoft Access MVP
"Mike Thomas" <mi**@ease.com> wrote in message
news:iT********************@newssvr28.news.prodigy .com...
In Access 2000, Win NT, Citrix, we have each user opening the front end mdb in their own folder, and linnking to the back end. I've noticed that a user can get more than one instance open at a time if they are not careful.

Is there a way to have an instance of Access check to see whether there is
another one already open for this user, and if so, simply to maximize the
window of the already running instance?

Thanks
Mike Thomas

Nov 12 '05 #2

P: n/a
Try looking here...

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

Mike Storr
www.veraccess.com
"Mike Thomas" <mi**@ease.com> wrote in message
news:iT********************@newssvr28.news.prodigy .com...
In Access 2000, Win NT, Citrix, we have each user opening the front end mdb in their own folder, and linnking to the back end. I've noticed that a user can get more than one instance open at a time if they are not careful.

Is there a way to have an instance of Access check to see whether there is
another one already open for this user, and if so, simply to maximize the
window of the already running instance?

Thanks
Mike Thomas

Nov 12 '05 #3

P: n/a
Many thanks,
The commonsense approach of opening the frontend exclusively was I had not
thought of.

Mike Thomas
"Wayne Morgan" <co***************************@hotmail.com> wrote in message
news:dF******************@newssvr33.news.prodigy.c om...
I don't know if this will work in Terminal Services or Citrix, but here is
an example you can try.

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

--
Wayne Morgan
Microsoft Access MVP
"Mike Thomas" <mi**@ease.com> wrote in message
news:iT********************@newssvr28.news.prodigy .com...
In Access 2000, Win NT, Citrix, we have each user opening the front end

mdb
in their own folder, and linnking to the back end. I've noticed that a

user
can get more than one instance open at a time if they are not careful.

Is there a way to have an instance of Access check to see whether there is another one already open for this user, and if so, simply to maximize the window of the already running instance?

Thanks
Mike Thomas


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.