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

Boot users - i'm sure i;ve seen this somewhere

P: n/a
Hi all,

I want to know if it is possible to control the users who are loggin
into the database i have created.

It uses front-end back-end but often i need to make database changes
that are back-end when users have forgotten to logoff their PCs.

Is it possible to forcibly boot a user from the database?

I'm certain i have seen this somewhere but can't find it now.

Any good ideas?

Rob.

Nov 13 '05 #1
Share this Question
Share on Google+
7 Replies


P: n/a
What I did to get round this problem is to have the main form (which is
always open) to check the value of a Boolean field (in a one record table)
every couple of minutes. Something along the lines of:

if Dlookup("Boot","Tbl_Booter") = true then
docmd.openform "Frm_Booter"
end if
Should this value be true, another form is then opened. The ontimer even of
this form is set to DoCmd.Quit

Regards,

Mark

"dkintheuk" <rm*******@firenet.uk.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...
Hi all,

I want to know if it is possible to control the users who are loggin
into the database i have created.

It uses front-end back-end but often i need to make database changes
that are back-end when users have forgotten to logoff their PCs.

Is it possible to forcibly boot a user from the database?

I'm certain i have seen this somewhere but can't find it now.

Any good ideas?

Rob.
Nov 13 '05 #2

P: n/a
Rob,

I do that often and for the same reason you want to. Some field
needs to be changed in the middle of the day and you need to kick
everyone off.
Anyway, I set a boolean in a table which all Main Menu's check
for its setting periodically. When they find it set to TRUE, all forms
are closed leaving only the Main Menu open and it has no bound
controls. A great big Red banner is displayed, explaining the
situation. So I can make my change, or sometimes do a compact. Then
I reset the flag and all the Main Menus see it, clear the banner, and
release the database for normal use.
I have seen no ill effects to the database from this practice
that I have been doing for years.
BTW, I use this same scenario to announce a code release so that
everyone knows to get out and back in to pick up the new front end.
Hank Reed

Nov 13 '05 #3

P: n/a
Mark, Hank,

Many thanks for the advice, of course that is the right way to do it. I
seem to find that nearly every question i ask recently has a real
kick-self solution.

Thanks again,

Rob.

P.S. I think i might refine it and put in a timer control to give users
a popup that they can close when i set the flag and then a set time
later it will perform the boot from all forms.

Gold stars all round!

Nov 13 '05 #4

P: n/a
dkintheuk wrote:
Hi all,

I want to know if it is possible to control the users who are loggin
into the database i have created.

It uses front-end back-end but often i need to make database changes
that are back-end when users have forgotten to logoff their PCs.

Is it possible to forcibly boot a user from the database?

I'm certain i have seen this somewhere but can't find it now.


There are several published solutions:

Arvin Meyer's "KickEmOff2K"
http://www.datastrat.com/Download2.html

Roger Carlson's LogUsersOff.mdb
http://www.rogersaccesslibrary.com/T...ontents3.asp#L

I'm sure there are other examples.
--
'---------------
'John Mishefske
'---------------
Nov 13 '05 #5

P: n/a
A few more for good measure:

http://home.bendbroadband.com/conrad...e/kickoff.html

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"John Mishefske" wrote in message:
news:42**********@newspeer2.tds.net...
dkintheuk wrote:
Hi all,

I want to know if it is possible to control the users who are loggin
into the database i have created.

It uses front-end back-end but often i need to make database changes
that are back-end when users have forgotten to logoff their PCs.

Is it possible to forcibly boot a user from the database?

I'm certain i have seen this somewhere but can't find it now.


There are several published solutions:

Arvin Meyer's "KickEmOff2K"
http://www.datastrat.com/Download2.html

Roger Carlson's LogUsersOff.mdb
http://www.rogersaccesslibrary.com/T...ontents3.asp#L

I'm sure there are other examples.
--
'---------------
'John Mishefske
'---------------


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Nov 13 '05 #6

P: n/a
OK - I get your point... it's funny i've noticed that a lot of the time
I end up searching for things and have to search for VERY specific
words to be able to find the pages I need.

I did search a fair bit for this , it's interesting that I hadn't been
able to find these MANY versions of the answer for myself.

It's very kind of you to post them for me.

Cheers,

Rob.

Jeff Conrad wrote:
A few more for good measure:

http://home.bendbroadband.com/conrad...e/kickoff.html

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"John Mishefske" wrote in message:
news:42**********@newspeer2.tds.net...
dkintheuk wrote:
Hi all,

I want to know if it is possible to control the users who are loggin
into the database i have created.

It uses front-end back-end but often i need to make database changes
that are back-end when users have forgotten to logoff their PCs.

Is it possible to forcibly boot a user from the database?

I'm certain i have seen this somewhere but can't find it now.


There are several published solutions:

Arvin Meyer's "KickEmOff2K"
http://www.datastrat.com/Download2.html

Roger Carlson's LogUsersOff.mdb
http://www.rogersaccesslibrary.com/T...ontents3.asp#L

I'm sure there are other examples.
--
'---------------
'John Mishefske
'---------------


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


Nov 13 '05 #7

P: n/a
You're welcome, glad to help.
Good luck with your project.

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"dkintheuk" <rm*******@firenet.uk.com> wrote in message
news:11**********************@g49g2000cwa.googlegr oups.com...
OK - I get your point... it's funny i've noticed that a lot of the time
I end up searching for things and have to search for VERY specific
words to be able to find the pages I need.

I did search a fair bit for this , it's interesting that I hadn't been
able to find these MANY versions of the answer for myself.

It's very kind of you to post them for me.

Cheers,

Rob.

Jeff Conrad wrote:
A few more for good measure:

http://home.bendbroadband.com/conrad...e/kickoff.html

--
Jeff Conrad
Access Junkie
http://home.bendbroadband.com/conrad...essjunkie.html
http://www.access.qbuilt.com/html/articles.html

"John Mishefske" wrote in message:
news:42**********@newspeer2.tds.net...
dkintheuk wrote:
> Hi all,
>
> I want to know if it is possible to control the users who are loggin
> into the database i have created.
>
> It uses front-end back-end but often i need to make database changes
> that are back-end when users have forgotten to logoff their PCs.
>
> Is it possible to forcibly boot a user from the database?
>
> I'm certain i have seen this somewhere but can't find it now.

There are several published solutions:

Arvin Meyer's "KickEmOff2K"
http://www.datastrat.com/Download2.html

Roger Carlson's LogUsersOff.mdb
http://www.rogersaccesslibrary.com/T...ontents3.asp#L

I'm sure there are other examples.
--
'---------------
'John Mishefske
'---------------


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----


----== Posted via Newsfeeds.Com - Unlimited-Uncensored-Secure Usenet News==----
http://www.newsfeeds.com The #1 Newsgroup Service in the World! 120,000+ Newsgroups
----= East and West-Coast Server Farms - Total Privacy via Encryption =----
Nov 13 '05 #8

This discussion thread is closed

Replies have been disabled for this discussion.