kick users out !

  • Thread starter Thread starter simon Guertin
  • Start date Start date
S

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
 
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.
 
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
 
Back
Top