Booting off logged in Users

[Bob Allen]

I currently just acquired the ability to view the list of
logged in users to a database...via
the "ShowUserRosterMultipleUsers" sub routine....

What i need to know is how can I, as the database
administrator, boot users out of the database when they
are logged in if they fail to log off when asked.?

Is there a way to boot an individual user off, and how?

Thanks,

Bob

 

[Armen Stein]

I currently just acquired the ability to view the list of
logged in users to a database...via
the "ShowUserRosterMultipleUsers" sub routine....

What i need to know is how can I, as the database
administrator, boot users out of the database when they
are logged in if they fail to log off when asked.?

Is there a way to boot an individual user off, and how?

Thanks,

Bob

Hi Bob,

Usually, the solution involves a hidden "sentinel" form that
periodically checks a field in a table to see if it should shut down the
application. We developed a whole auto-logout system that prompts all
the users with a configurable message, then counts down a configurable
number of minutes before logging them out.

To boot an individual user, the sentinel form would need to check a
table to see if that particular user is being booted. We haven't done
that, but it seems feasible.

 

[Armen Stein]

I've always been hesitant to do this, in case the user is in the middle of a
substantial update process.

Hi Joan,

Yes, it's definitely not for every application. Our approach is to give
lots of warnings before actually shutting down, but you never know what
someone is in the middle of. It works okay for an application that
consists mostly of short term updates and reporting. We have rarely
used it; it's just in our bag of tricks when we need it.

Another method is to walk around and ask everyone to log off! Promotes
teamwork, provides exercise, etc.

 

[Tony Toews]

Another method is to walk around and ask everyone to log off! Promotes
teamwork, provides exercise, etc.

But some of my clients users are some 3480 km away by road. <smile>

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Tony Toews]

I've always been hesitant to do this, in case the user is in the middle of a
substantial update process.

Yeah, that has been a problem at a clients. Some batch processing
runs for over an hour.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

 

[Dirk Goldgar]

Yeah, that has been a problem at a clients. Some batch processing
runs for over an hour.

In the case of processes you, the developer, designed, it seems to me
you could set an "in process" flag somewhere and include a test of this
flag in your auto-shutdown code. It wouldn't auto-shutdown if this
flag is set. You might need to allow for a "force" option, blowing
users out even if the "in process" flag is set, to be used only in
emergencies.

 

[Tony Toews]

In the case of processes you, the developer, designed, it seems to me
you could set an "in process" flag somewhere and include a test of this
flag in your auto-shutdown code. It wouldn't auto-shutdown if this
flag is set. You might need to allow for a "force" option, blowing
users out even if the "in process" flag is set, to be used only in
emergencies.

Oh yes, that's exactly what I plan on doing once the user starts to
run that particular batch operation again. They're currently in the
middle of a huge job, about $50 or $80 million which uses a different
process for that particular function. And they aren't taking on any
new medium sized jobs which would use that particular function for a
while.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm