New Features in Total Access Admin 2007
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 Access 2007 databases in ACCDB format
In addition to supporting all Access/Jet MDB databases from Access 97 to 2007, Total Access Admin 2007 also supports 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
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.
Enhanced 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 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.
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.
Features
See Who's in Your Access Database
Quickly see who is currently logged into your database either directly or through linked tables. Databases can be password protected or secured through a workgroup file. The workstation name, their Access/Jet login name, and connection status are revealed. Suspect connections are shown and if someone exits, the time they left is shown.
The latest version lets you log all the user connections so you can record when people come in and out of the database. The information is stored in a table in a separate log database.
Prevent New Connections to the Access Database
This great feature makes it easier than ever to prepare a database for backups, compact/repair, or other maintenance operations. Set at the Access/Jet database engine level, this option prevents new users from loading the database, giving you time to kick out the existing users. (This feature is supported in Jet 4.0 or later and is not available for Access 97 or earlier).
Automatically Disconnect Idle Users
When a user leaves their computer on with your Access or Jet/VB database open, it can be impossible to get the database closed for maintenance until you track them down. Use Total Access Admin to automatically log users out of a database after a specified period of inactivity.
Compact Database When All Users Exit
If you'd like, when all the users exit the database, Total Access Admin can get a full lock and compact the database.
Identify Dropped or Suspect Connection
A dropped connection to an Access/Jet database can lead to database corruption. Total Access Admin identifies workstations or users who left the database in a suspect state. This can be invaluable for pinpointing a potential database corruption source.
Not only can you use the log file to store when this occurs, you can also have Total Access Admin automatically compact the database once a suspect connection is detected and everyone else has exited.
Send Messages to Application Users
Use Total Access Admin to communicate in real time with your application users. Simply type in a message and it appears in every instance of your application. Great for sending update or maintenance/log-out messages.
How it Works
Total Access Admin runs as a stand alone program. Install it on a machine that has a version of Access supporting the database formats desired, then run it. Point it to the database you want to examine and the list of users are displayed. Your database can reside anywhere on your network that you have rights to see.
Total Access Admin can also be run from the command line with all the user interface options, making it easy to create a shortcut for regularly checked databases.
100% Guaranteed
Total Access Admin is 100% guaranteed to pay for itself the first time you use it. Easily monitor and maintain Access/Jet Engine databases. Control access and effectively communicate with users. If you are not completely satisfied with Total Access Admin, return it within 30 days for a complete refund.
Part of the Total Access Solution
Total Access Admin is a member of the award-winning family of Access add-ins that make your life easier. Like our Total Access Analyzer and Total Visual Agent products, Total Access Admin makes it easier to maintain your Access and VB projects.
Supported Versions
Total Access Admin supports Microsoft Access/Jet databases in Access 97, 2000, and 2002/2003/2007 database formats. It supports databases in MDB and the new Access 2007 ACCDB formats.
- How do you close a database for maintenance or backups when other users have it open?
- How can you automatically log off idle users?
- How can you identify workstations or users that are causing database corruption?
- How do you communicate with your Access/VB application users in real-time?
- How do you see who is currently using your application or database?
Total Access Admin solves all these problems in one easy-to-use program. Simply start the program, point to your database, and you have complete control to:
Prevent any new connections to the database. This great feature makes it easier than ever to prepare a database for backups, compact/repair, or other maintenance operations.
Automatically disconnect idle users. When a user leaves their computer on with your Access or VB database open, it can be impossible to get the database closed for maintenance until you track them down. Use Total Access Admin to automatically log users out of a database after a specified period of inactivity.
Identify Dropped or Suspect Connections: A dropped connection to an Access/Jet database can lead to corruption. Total Access Admin identifies workstations or users who have left the database in a suspect state. This can be invaluable in tracking down corruption issues.
Send Messages to Application Users: Use Total Access Admin to communicate in real time with your application users. Simply type in a message and it appears in every instance of your application. Great for sending update or maintenance/log-out messages.
Total Access Admin is also available as part of:
- Total Access Ultimate Suite
Total Access Admin is licensed on a per user basis. Each user who runs the program must have a license.