Booting people out of a front end

[Mark Reed]

Hi all,
Is there any way that I can boot people out of a front end so that I can
do work on the backend which I need to have exclusive access to. Due to an
application I have used to keep the front end up to date, I can keep people
from opening it once they have been booted which doesn't help with people
that already have it open!!!!

I am using Access XP and have no programming experience.

Thanks in advance,

Mark

[Hank Reed]

"Mark Reed" <ma*********@ntlworld.com> wrote in message news:<Xqfvc.13$vc7.1@newsfe2-win>...

Hi all,
Is there any way that I can boot people out of a front end so that I can
do work on the backend which I need to have exclusive access to. Due to an
application I have used to keep the front end up to date, I can keep people
from opening it once they have been booted which doesn't help with people
that already have it open!!!!

I am using Access XP and have no programming experience.

Thanks in advance,

Mark

Mark,
I have the same situation. What I do is set a boolean
expression to TRUE in a special table. Every user's code checks for
this flag about once a minute. If it is set, their code closes every
form except the main menu. At that point no one has a back-end table
connection. I also put up a large warning on the screen to not use
the database. When I complete my work, I clear the flag.
I'm only responding because I like your name. :-)
Hank Reed

[Mark Reed]

Hank,
Your right, it is a cool name. Thanks very much for your idea. So simple
and so effective. Worked a treat :-)
"Hank Reed" <ha********@aol.com> wrote in message
news:f4**************************@posting.google.c om...

"Mark Reed" <ma*********@ntlworld.com> wrote in message

news:<Xqfvc.13$vc7.1@newsfe2-win>...

Hi all,
Is there any way that I can boot people out of a front end so that I can do work on the backend which I need to have exclusive access to. Due to an application I have used to keep the front end up to date, I can keep people from opening it once they have been booted which doesn't help with people that already have it open!!!!

I am using Access XP and have no programming experience.

Thanks in advance,

Mark

Mark,
I have the same situation. What I do is set a boolean
expression to TRUE in a special table. Every user's code checks for
this flag about once a minute. If it is set, their code closes every
form except the main menu. At that point no one has a back-end table
connection. I also put up a large warning on the screen to not use
the database. When I complete my work, I clear the flag.
I'm only responding because I like your name. :-)
Hank Reed