How to know if instance is already running

[Mike Thomas]

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

[Wayne Morgan]

Re: How to know if instance is already running

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" <mike@ease.co m> wrote in message
news:iT5Wb.1550 $t16.1247441@ne wssvr28.news.pr odigy.com...[color=blue]
> In Access 2000, Win NT, Citrix, we have each user opening the front end[/color]
mdb[color=blue]
> in their own folder, and linnking to the back end. I've noticed that a[/color]
user[color=blue]
> 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
>
>[/color]

[Mike Storr]

Re: How to know if instance is already running

Try looking here...

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

Mike Storr

https://www.veraccess.com

"Mike Thomas" <mike@ease.co m> wrote in message
news:iT5Wb.1550 $t16.1247441@ne wssvr28.news.pr odigy.com...[color=blue]
> In Access 2000, Win NT, Citrix, we have each user opening the front end[/color]
mdb[color=blue]
> in their own folder, and linnking to the back end. I've noticed that a[/color]
user[color=blue]
> 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
>
>[/color]

[Mike Thomas]

Re: How to know if instance is already running

Many thanks,
The commonsense approach of opening the frontend exclusively was I had not
thought of.

Mike Thomas
"Wayne Morgan" <comprev_gothro ughthenewsgroup @hotmail.com> wrote in message
news:dF6Wb.3355 2$Vx4.5645@news svr33.news.prod igy.com...[color=blue]
> 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" <mike@ease.co m> wrote in message
> news:iT5Wb.1550 $t16.1247441@ne wssvr28.news.pr odigy.com...[color=green]
> > In Access 2000, Win NT, Citrix, we have each user opening the front end[/color]
> mdb[color=green]
> > in their own folder, and linnking to the back end. I've noticed that a[/color]
> user[color=green]
> > 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[/color][/color]
is[color=blue][color=green]
> > another one already open for this user, and if so, simply to maximize[/color][/color]
the[color=blue][color=green]
> > window of the already running instance?
> >
> > Thanks
> > Mike Thomas
> >
> >[/color]
>
>[/color]