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

Booting people out of a front end

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"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
Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.