kick out users after a certain time of idle (1 Viewer)

[alhabkk]

Hi all,

Is there any option to kick out users after a certain time of idle.

Say, a user login my ms access and don't logout from database and he don't do anything in ms access. I want automatically logout from ms access after a certain time he is idle.

For your information i'm using ms access 2007.

Thanks in advance.

 

[RuralGuy]

Here's a list of options: http://www.accessmvp.com/JConrad/accessjunkie/kickoff.html

 

[MLUCKHAM]

I implemented this, but to do it I put code to log out on the timerInterval of the main form of the database. This timerInterval was enabled on the form load and the timerInterval set to 10 second. Every 10 seconds the form would increment a counter which was declared as a global at the top of the form. In the timerInterval I tested the counter and if it was greater than 30 then the user was logged out (5 minutes)

I then put some code on the mouseMove event on the detail section on the form which reset the counter to 0 everytime the mouse moved. Also added a function that reset the counter if the form loaded another form etc.

It works, but takes a little bit of time to set it up.

 

[alhabkk]

Could sombody explaine it to me step by step. im struggling!

 

[RuralGuy]

Did you select one from the link I gave you? If so, which one?

 

[alhabkk]

Did you select one from the link I gave you? If so, which one?

I'm trying to use this code...

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

 

[alhabkk]

its give popup message only, i need to kick users out of db

 

[RuralGuy]

Have you created the form as the link suggests? Do you open it hidden with the AutoExec macro as suggested?

 

[RuralGuy]

You need to add this line:
Application.Quit acSaveYes

...like this:

If ExpiredMinutes >= IDLEMINUTES Then
   ' ...if so, then reset the expired time to zero...
   ExpiredTime = 0
   ' ...and call the IdleTimeDetected subroutine.
   IdleTimeDetected ExpiredMinutes
   [COLOR="Red"][B]Application.Quit acSaveYes[/B][/COLOR]
End If

 

[alhabkk]

You need to add this line:
Application.Quit acSaveYes

...like this:

If ExpiredMinutes >= IDLEMINUTES Then
   ' ...if so, then reset the expired time to zero...
   ExpiredTime = 0
   ' ...and call the IdleTimeDetected subroutine.
   IdleTimeDetected ExpiredMinutes
   [COLOR=red][B]Application.Quit acSaveYes[/B][/COLOR]
End If

wow u made my work a piece of cake
now its work greate but I would like to kick users automatically ( without shoing pop-up message)? and in case i want auto Logout Users from DB for maintenance?

Thanks alot RuralGuy

 

[RuralGuy]

If you want to kick off the user without showing the MsgBox then don't call the IdleTimeDetected procedure.

 

[alhabkk]

If you want to kick off the user without showing the MsgBox then don't call the IdleTimeDetected procedure.

Its work....
Thanks alot
there is away to force users to kick them in case of maintenance ?