This may have been answered before, but I can't find it...Besides the
code listings that will terminate an inactive user after a period of
inactivity (*using the Timer event), can anyone share some ways to force
users off if necessary? We have situations, for example, where we have
spot inspections of the database, and we may need to manually
"disconnect" all users immediately, maybe with a quick message box
telling them we're about to do so.
thanks for any help,
E
glenn - 12 Sep 2003 09:37 GMT
See KickEmOff2k at Arvin Meyers site :
http://www.datastrat.com/Download2.html
Works very well for me.
>-----Original Message-----
>
[quoted text clipped - 13 lines]
>Posted via http://dbforums.com
>.
Glenn - 12 Sep 2003 09:46 GMT
Forgot to mention. read the following file first:
http://www.datastrat.com/Code/KickEmOff.txt
>-----Original Message-----
>See KickEmOff2k at Arvin Meyers site :
[quoted text clipped - 27 lines]
>>
>.
Frank Konzal - 16 Sep 2003 12:07 GMT
I experimented with this a little while ago. Add a hidden form to the
application with a timer that checks for one particular field. I made this
form the startup form - it then called the original startup form. This
hidden form has a timer set to your specifications which checks the one
field for whatever factor you choose - I tried a date and time field so that
I could put in a time maybe ten minutes out which the form would read and
msgbox the user that the app was ending at that time. At that time the app
would end - with save.
> This may have been answered before, but I can't find it...Besides the
> code listings that will terminate an inactive user after a period of
[quoted text clipped - 10 lines]
> --
> Posted via http://dbforums.com