Re : Inactivity Detection in Access.
NeoPa,
I just encountered a very strange occurrence with this code (using Access 2010).
First off, this code works. Thanks much for the work you've done.
However, I have experienced a very strange situation when I run this code on one form, but not the other. I will give an example: I open my DB, which opens the Switchboard Form, which has this function in the timer. I use 30 minutes as the time to kill the DB if the user has not touched the db. After 30 minutees, the DB dies, as expected.
When I navigate to another form (which also closes the switchboard), which does not have this code in the Timer Event, and I use this form for a long time (i.e. "not idle"), and then close that form (which opens the Switchboard again), the switchboard will appear for a split second and then the DB will quit on me.
When I used the system idleness (see Post #2), I had no problems, but when I transitioned to an Access-specific idleness, this was the result.
Any ideas why this would be happening?