Log off users on split DB

  • Thread starter Thread starter Neil Greenough
  • Start date Start date
N

Neil Greenough

I recently posted on the microsoft.public.access NG a similar message,
however I am after a more specific answer. The other NG recommended I see
the "KickEmOff2K sample Arvin Meyer has at
http://www.datastrat.com/Download2.html."

Basically, If I have a multiuser split database and want to create a back-up
of the backend, is there a way of logging off users giving them a message
saying something like "You have 5 mins to complete your work before you will
be logged off. This is due to administration reasons" and then actually
being able to log them off? This message will appear on the front ends of
all users logged on at that time?

I know there are things such as Total Access Admin software, however just
wondering if my work will fork out the money for such, and if not......

Thanks
 
This is the exact same question to which I responded in m.p.access.

If that answer wasn't sufficient, what are your additional requirements that
the two solutions I suggested didn't meet?
 
Doug,

Thanks for your reply (again!) Basically, I would like a message to pop up
on the computers of those who are using the database (front end) saying "You
have 5 minutes to log off." After 5 minutes, I would then like this code to
log them off automatically.

Your original reply doesn't actually give the users a chance to log off
(AFAIA)

Thanks in advance
 
Well, I can't comment on whether Arvin's code does that, as I haven't
actually looked at it, but the KB article certainly can be made to.

The original IdleTimeDetected routine (step 4) pops up a message. Rather
than using a message box, open up a form that has a message saying "You're
going to be logged off in 5 minutes". Put a 5 minute timer in that form that
shuts the database at the end of 5 minutes.
 
Many thanks :)

Douglas J. Steele said:
Well, I can't comment on whether Arvin's code does that, as I haven't
actually looked at it, but the KB article certainly can be made to.

The original IdleTimeDetected routine (step 4) pops up a message. Rather
than using a message box, open up a form that has a message saying "You're
going to be logged off in 5 minutes". Put a 5 minute timer in that form
that shuts the database at the end of 5 minutes.
Click to expand...
 
Back
Top