>I have an executable that runs in the middle of the night when
>(most) of us are sleeping. This exe captures downloaded files from an AS400 and refreshes many of my tables for my application. I also take this opportunity to pack and reindex my tables since I have exclusive use of all tables. This is where I am having some trouble. Everything works okay while running this exe as long as all of my users are logged out of the app, but if a user forgets to log out, my exe obviously will bomb since I need exclusive use to pack & reindex.
>What is the best way to boot out all users after an extended period of idle time, or better yet, at a pre-determined time so my exe can do its thing? any suggestions appreciated!!
>
>John.
John,

I wound up setting events tracking to a filename unique to the current user. Then I check the size of the file at an interval assigned to that user with a timer. If the user does anything in the predetermined time frame, the events tracking log will be larger in bytes than before. However, this makes the timeout interval equal to the Interval+what was left in the previous timer loop. No big deal. The events tracking log works well because you can also set the events you want to track with the events tracking list. This log tracks the use of any control on any form in the app, or even a mousemove in _screen.

Just one idea...

Eric K.