473,320 Members | 1,936 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

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

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
7 1480
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
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
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
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

5
by: dfg | last post by:
Can I write a boot sector using VB? Is there some built in library, or is it possible to make my own? Can I embed Assembly language? Getting ready to work with Visual Basic for the first...
33
by: john bailo | last post by:
I just noticed something since i upgraded one of my two gateway celerons at work to rh9. with windos, if i press the on/off button, it goes into a windows shutdown. or, more likely, it locks up...
0
by: Per Bergland | last post by:
After many woes, I finally managed to get a stack dump of my System Service (written in C#) that insists on crashing when launched at system boot time (see below on how to get this dump - I...
6
by: mark | last post by:
I have an asp.net ecommerce web application on a remote web server. I'm using an Access database on the back end. I've notice a few strange things. When I mimic an multiple user environment by...
4
by: Shane | last post by:
I've created a wallpaper changer that I want to start up on system boot. I know that I can put a shortcut for my app in the startup folder. How can I get the install program for my app to add a...
2
by: Jim in Arizona | last post by:
My goal, somehow, is to populate a dropdownlist with all the user names in active directory. I don't even know where to begin, really. I added a reference to System.DirectoryServices so I could...
17
by: HangEveryRepubliKKKan | last post by:
After several days of playing with Linux I just told the update manager to update all components of the OS and all installed programs. After completing it's tasks my machine now refuses to boot. ...
0
by: Chris Calloway | last post by:
Triangle (NC) Zope and Python Users Group (TriZPUG) is proud to open registration for our fourth annual ultra-low cost Plone and Python training camps, BootCampArama 2008: ...
4
by: Hero Doug | last post by:
A friennd and I were talking about OS development last night and a few questions were raised that need some clarification. I did the usual search and it turned up the usual garbage, so I'm hoping...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.