New Features in Total Access Admin 2003 (Version 11.6)

Why Would I Need the 2003 Version?

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).

Total Access Admin 2003 Enhancements in Version 11.6 from Version 11.5

Version 11.5 was introduced with the release of Total Access Admin 2010. Enhancements since that version include:

  • Supports Windows XP through Windows 10, and Windows Server 2012 and later
  • Increases the maximum number of databases that can be simultaneously monitored from 100 to 150
  • Translates obscure computer names to a more understandable user name from a list you maintain
  • Enhances the activity log database to include user names
  • Allows specifying a time for the program to quit (exit)
  • Adds new command line parameters to specify the hours and seconds to wait before quitting
  • Includes code in the sample database to support 32 and 64-bit Access VBA
  • Adds setup options to install for the current user or machine to support User Access Control rights as established by your Windows login
  • Includes a new user manual and help file

Enhancements added in version 11.5 from 11.0 are provided here: Total Access Admin 2003 (version 11.5)


New Features

These new features were added to the main form:

Total Access Admin New Features

User Name Display

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.

New Options Form

The new options form lets you manage the two external databases for Total Access Admin.

Total Access Admin Database Options

Database with Computer User Names

This is the database containing the translation table of computer names to user names. Open and edit this database to manage your list:

User Names for Computers

Database of Activity Log

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).

Activity Log
All Activities

Activity Log by Session
Activities for Each Time Total Access Admin is Launched

Specify a Time to Quit (Exit)

Specify Time for Total Access Admin to Quit

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.

New Command Line Parameter for Waiting/Quitting

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).


Enhancements in Other Versions

For features added to other versions:

Total Access Admin Manual

Microsoft Access 2016 Version is shipping!

New Features

Also Version 11.6 for Access 2003 and earlier

Supports database formats for Microsoft Access 2016, 2013, 2010, 2007, 2003, 2002, 2000, and 97


View all FMS products for Microsoft Access All Our Microsoft Access Products

Reviews

"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

Admin Info

Additional Info

 

 

Free Product Catalog from FMS