Total Access Admin is an administrator tool to help you monitor the users going in and out of your Microsoft Access databases (ACCDB and MDB formats).
How do I configure my database to use the Idle User Logout feature in Total Access Admin?
For your application to support the Idle User Logout feature, you must include some additional functionality. Sample databases are provided in your Total Access Admin folder. Source code examples are provided for both ADO and DAO database library references:
You can use these databases to test the Total Access Admin features.
Set Idle User Logout Settings
Use the frmIdleSettings to set the Idle User values:
The values are stored in the FMS_IdleLogout table:
Note that there is a maintenance window which defines the period of time that the Idle User Logout feature is active. In the example, it's from 6 PM to 6 AM.
If you want it to be active all the time, uncheck the Enable Maintenance Window checkbox:
Import Objects into Your Database
The easiest way to implement this is to import these items from the sample database into your application:
- Table: FMS_IdleLogout
- Forms: frmStartup, frmAdministrator
Please refer to the Idle User Logout topic in your user manual or help file for full details about importing these objects.
If your application has an existing Startup routine, or if you want to integrate the functionality into existing forms, you may want to support the Idle User Logout feature without importing our sample objects. If you are more experienced with Access VBA/VB6 development, you can implement the feature by doing the following:
- Create a table named FMS_IdleLogout similar to the sample database.
- Add refresh logic to your database to periodically examine the value of the enabled field. If it's set to true, determine how long the user has been idle, and close the database if they have been idle for the specified amount of time.
Refer to the Idle User Logout topic in your user manual or help file for full details about implementing this feature.