With the release of Total Access Admin for Microsoft Access 2013, Total Access Admin for Microsoft Access 2003 was also enhanced to include the new features. The primary reason for keeping the 2003 version is to support environments that only support the Microsoft Access MDB database format without supporting the ACCDB format introduced with Access 2007. The latest version of Total Access Admin supports both formats, but cannot run on machines that do not support ACCDB files (environments where the newer ACE Access Database Engine is installed).
Version 11.5 was introduced with the release of Total Access Admin 2010. Enhancements since that version include:
Enhancements added in version 11.5 from 11.0 are provided here: Total Access Admin 2003 (version 11.5)
These new features were added to the main form:
The most popular addition to Total Access Admin 2003 is the display of the user name for each computer name. Microsoft Access/Jet only knows what computer is connected to a database and not the actual user name. You can now create and maintain a list of computers with their user names to better understand who's in your databases. Provided multiple people aren't using the same computer, this works very well.
The new options form lets you manage the two external databases for Total Access Admin.
This is the database containing the translation table of computer names to user names. Open and edit this database to manage your list:
This is the database with the log of all your users entering and exiting your databases. This database stores the new UserName and has two new forms that show all the activities and by session (times when Total Access Admin starts and exits).
Activities for Each Time Total Access Admin is Launched
Previously, Total Access Admin could be set to exit for certain actions such as when all users exit the databases.
You can now specify a specific time to exit regardless of other activity in your databases. Just specify any date/time in the future.
If you launch Total Access Admin from a command line, you can specify all the UI settings. For the time to quit, new parameters are available to specify the hours and/or seconds before closing. This makes it easy to set the time to quit without having to know the current time (e.g. you can set it to close an hour after starting).
For features added to other versions:
Also Version 11.6 for Access 2003 and earlier
Supports database formats for Microsoft Access 2016, 2013, 2010, 2007, 2003, 2002, 2000, and 97
"Total Access Admin is a tool of immense value for any database administrator, so if you are one, don't miss this chance to make your life so much easier!"
- Nikolaev Alexander Dmitrievich
"Seeing live who's going in and exiting an Access database is incredibly helpful for supporting our multi-user environment"
- FMS Customer