Automatic shutdown of Access

[davidg47]

Hi everyone,

Is there a way to automatically shut down Access after a given amount of time?

I have an Access application that runs across a network. Access is the front end of a SQL Server 2000 database.

Some of the users forget to close their application at night when they leave for the day. When I come in in the mornings, I like to run the Compact and Repair, but can't because someone is still logged in. So then I have to go to each and every computer to see if they are still logged in. By the time I vist each computer, the morning is almost started and people ARE logging in for the day.

So I'm hoping to find an application that will automatically either log each computer off across the network, or that will log the application off of each individual computer after a given amount of inactivity.

Thanks for your help...

 

[TanisAgain]

Yes, you can. The microsoft Knowledge base has two articles that might help. The first detects idle time or inactivity so that you can close the DB safely, and the second compacts and repairs at set times.

http://support.microsoft.com/?id=210297

and

http://support.microsoft.com/kb/209979/en-us

 

[RuralGuy]

And here's a rather lengthy list of "Kick 'um off" type links from MVP Jeff Conrad. Kick Users Off - Detect Idle Time