New Features in Total Access Admin 2007

This page is a reference for a legacy version of Total Access Admin.
The latest version of Total Access Admin is described here: New Features

Total Access Admin 2007 (Version 12.0) lets you monitor your Microsoft Office Access/Jet databases better than ever and includes many new features:

Support for Microsoft Access 2007 databases in ACCDB format

In addition to supporting all Microsoft Access/Jet MDB databases from Access 97 to 2007, Total Access Admin 2007 also supports MS Access 2007 ACCDB format databases. Support for this format requires Access 2007 to be installed on the machine.

Save Database Connections and Disconnects to a Log file

Optionally store every connection and disconnection from a database in a log file. This is stored in a table of the LOG.MDB database where Total Access Admin is installed. It records the machine ID, user name, and time. If a suspect connection is detected, that's recorded as well.

Enhanced Actions when All Users Exit the Database, Including Automatic Compact

In addition to displaying a notification when all users are closed, these options are now available:

  • Compact the database, then close the database or exit Total Access Admin
  • Close Total Access Adminís connection to the database
  • Exit Total Access Admin

This makes it easy to compact the database once everyone exits. Database compact is made with extra care to ensure that a successful copy is made before the original is replaced.

Additional Actions when a Suspect Connection Occurs

If a suspect connection is detected, these options are now available:

  • Close Total Access Adminís connection to the database
  • Display a notification on-screen
  • Lockout new users, and logout idle users
  • Lockout new users, logout idle users, then compact the database
  • Exit Total Access Admin

Command Line Support

Total Access Admin 2007 can be launched from a command line, Windows shortcut, or batch file. The database name, login info, and all the interactive selections can be set from the command line to simplify repetitive tasks.

Idle User Logout Seconds

If you implement the Idle User Logout feature in your database, there's a new option to let you specify the number of seconds it should wait before logging out the user automatically.

Enhanced User Interface

In addition to supporting Microsoft Access 2007, the new version is also tested against Vista, and offers a streamlined and improved user interface:

  • Settings for opening a database retain the previous entries for workgroups and passwords
  • Most recently used list of databases
  • Larger form to show more connections
  • Support for Windows XP themes

Additional Documentation and Samples

A new help file and 50-page professionally printed user manual are included. The sample databases are also enhanced with separate examples for ADO and DAO.

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


"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