Kerri Storr
New member
- Local time
- Today, 07:57
- Joined
- Mar 11, 2002
- Messages
- 8
Is there a way in Access 97 that you can boot people out of your database, even if their machine is locked? i.e. can you close access on some elses's machine remotely?
Logging users off
- Thread starter Kerri Storr
- Start date
sambo
Registered User.
- Local time
- Yesterday, 23:57
- Joined
- Aug 29, 2002
- Messages
- 289
Put a checkbox (bootCheck) on a hidden form that is always open to all users logged on.
Now set the form timer to 60000 (once a minute, or whatever you choose) and in the on timer event put this code.
Now all you have to is create a way that you can "unhide" the form. (You can put a double-click event on a form somewhere that no one would think to double-click or something like that.) Have this double-click set the "hidden" form to "visible". Now just go and check the bootCheck Checkbox. Within a minute or so everyone will be "Booted" off.
There is a much better way to do this, but this is a messy little method to accomplish what you want to do.
Now set the form timer to 60000 (once a minute, or whatever you choose) and in the on timer event put this code.
Code:
If Me.bootCheck = -1 Then 'The box is checked
Access.Application.CloseCurrentDatabase
End IfNow all you have to is create a way that you can "unhide" the form. (You can put a double-click event on a form somewhere that no one would think to double-click or something like that.) Have this double-click set the "hidden" form to "visible". Now just go and check the bootCheck Checkbox. Within a minute or so everyone will be "Booted" off.
There is a much better way to do this, but this is a messy little method to accomplish what you want to do.
