Specific Time to Log Idle Users Off

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vylent Fyre - 30 Oct 2007 19:36 GMT

I've implemented the following procedure using this guide -

http://support.microsoft.com/default.aspx?scid=kb%3ben-us%3b210297

Now my main thing is to have it to where it'll run after 7:00 pm - Is there
a way to do this? Should the Database be closed, or opened? Should I run a
macro to do this every evening before I leave for the day? Any suggestions
would be greatly appreciated!!

Reply to this Message

Douglas J. Steele - 30 Oct 2007 20:20 GMT

That code shows how to shut down the database if the user hasn't used it for
a specific period of time. It's not a macro that runs at a specific time:
it's intended to be running all the time the database is open.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I've implemented the following procedure using this guide -
>
[quoted text clipped - 7 lines]
> suggestions
> would be greatly appreciated!!

Reply to this Message

Vylent Fyre - 31 Oct 2007 16:53 GMT

Yes, that is correct - I am aware of that. My problem is, my managers do not
want it run throughout the day until after everyone has left for the day,
which is generally after 6:00pm, 7:00 pm at the latest.

I wanted to know if it was possible to implement this? Once it's 7:00 pm,
it will run DetectIdleUsers? We do have quite a few people who don't shut
the database down before they leave for the day....

(Yes, I'm aware I'm ignorant in this regard... But I'm willing to learn! :) )

VF

> That code shows how to shut down the database if the user hasn't used it for
> a specific period of time. It's not a macro that runs at a specific time:
[quoted text clipped - 11 lines]
> > suggestions
> > would be greatly appreciated!!

Reply to this Message

Douglas J. Steele - 31 Oct 2007 17:31 GMT

What you need to do is set the form's TimerInterval property to 0 when you
don't want it to run, and to a non-zero value (the article suggests 1000)
when you do. The problem, though, is that there's no way to set that
property automatically unless you've got a timer running on the machine,
checking to see what time it is and then deciding whether or not to change
the TimerInterval property.

If you're going to have to have a timer running anyhow, you may as well just
run that code. You could have IDLEMINUTES as a variable and change its value
depending on the time of day so that it's not so aggressive during business
hours.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Yes, that is correct - I am aware of that. My problem is, my managers do
> not
[quoted text clipped - 27 lines]
>> > suggestions
>> > would be greatly appreciated!!

Reply to this Message