Specific Time to Log Idle Users Off

[Vylent Fyre]

I've implemented the following procedure using this guide -

http://support.microsoft.com/default.aspx?scid=kb;en-us;210297


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!!

 

[Douglas J. Steele]

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.

 

[Vylent Fyre]

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

 

[Douglas J. Steele]

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.