kick users out !

[simon Guertin]

Hi, is it possible in access vba to kick users out of the
database? I was thinking about putting a certain value in
one table and the user's front end would poll this table
every 2 minutes the see if they need to be kicked out?
Can I make a thread to do this? What other options could I
use?

Thanks

Simon

 

[Eric Isaacs]

when the application opens, open a "kick em out" form and
make it invisible on open of your MDB file. Set a timer
event in that form that checks that table's field value.
(I suggest having the field value set to a time, so the
users machine will know when they need to be out.)

Then just have the timer event prompt the user to close by
that time.

I would suggest not using a msgbox for this prompt,
however, since all code will hang until the user closes
the message box. If you use a message form that's modal,
you can make the user clear it before they can continue,
but also allow other code to run until the message is
cleared, so you can kick them out if the time elapses and
they haven't cleared the message box yet.

 

[Bret]

you can also try a idle timer per the MSKB....

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

 

[rob]

I used to work with a text-file, and let access check for
the existance of that file evry once in a while.. I fthe
file isn't there anymore, a messagbox pops up, saying tha
app will be closed in a couple of minutes, so the user can
save his record.

Rob

 

[RobFMS]

This product will do what you need, and more.
Definitely worth the price!

Total Access Admin
http://www.fmsinc.com/Products/Admin/index.asp

--

Rob

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Problems with your database? Need to upgrade your application?
Contact the FMS Professional Solutions Group: www.fmsinc.com/consulting

Need a Book Recommendation?
www.fmsinc.com/toplevel/books.htm

Need software tools for Access, VB or .NET?
http://www.fmsinc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-