Monitor the Activity of Your Microsoft Access/Jet Engine Databases in Real-Time
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):
- See who is currently connected to your Microsoft Access database
(you can manage multiple databases from one screen)
- Keep a log of users entering and exiting your database
- Identify workstations or users disconnecting in a suspect manner which may be the source of database corruption
- Compact your database when all users exit it
- Prevent new users from logging into your database
- Log off idle users
- Communicate with your users in real-time
Total Access Admin is an easy-to-use,
standalone program. Simply launch the program and point it to your databases
across your network! You'll enjoy seeing the activity in real-time. It's
especially helpful if you need to kick out everyone in the database and want
to know who's currently in using it.
Total Access Admin main form to monitor Microsoft Access databases
VERSION FOR MICROSOFT ACCESS 2013, 2010 and 2007
- Supports all Access database formats including the
ACCDB format from Access 2007, 2010 and 2013
- Open and monitor multiple databases at one time (up to
- See more friendly user names in addition to computer
- New forms in activity log to view database entries and
exits by session
- Set a specific time to close the program
- New command line parameters for quitting
- Sample database includes 32 and 64-bit Access VBA code
- New Features...
See Who's in Your Microsoft Access Databases
Quickly see who is currently logged into your databases either directly or
through linked tables. Total Access Admin supports databases that are password protected or secured
through a workgroup file. Multiple databases can be monitored at one time. 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.
Watch Users Connect and Disconnect from All Your Databases
User Name Display NEW!
The most popular addition to Total Access Admin 2013 is
the display 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 makes it much
easier to see who's in your database.
Log User Connections to a Database
Record all the user connections to track when people enter and leave each database. The information is
stored in a table in a log database you specify. The data is in MS Access
tables, so you can easily query and perform additional analysis on it.
The log now contains the user name and forms to show all
the activity and activities by session: NEW!
Activities for Each Time Total Access Admin is Launched
Prevent New Connections to Your Microsoft 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
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. You can specify the number
of seconds it should wait before logging out the user automatically.
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. 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.
Other options include closing the database, displaying a message, and exiting Total Access
Identify Dropped or Suspect Connections
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. These options are
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
a Time to Quit NEW!
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.
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.
Command Line Support
Total Access Admin 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
How it Works
Total Access Admin
runs as a stand alone program. Install and run it from a machine that has
a version of Access supporting the database formats desired.
Point it to the databases you want to examine and the list of users is displayed.
The databases 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
LACCDB and LDB Viewer
Technically, Total Access Admin is an LACCDB and LDB Viewer. When you
open an Access Jet database (either ACCDB or MDB format), a lock file is
created with a *.LACCDB or *.LDB extension. Total Access Admin lets you peek
into these files to see who's currently using them. By monitoring them over
time, it can determine when people leave, if they break their connections
unexpectedly, and to prevent new users from opening the database.
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
Total Access Admin is a
member of the award-winning family of Microsoft Access products 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 VB6 projects
using Microsoft Access databases.
Pricing and Versions
Total Visual Admin supports all recent Microsoft Access/Jet versions. Two
versions are available depending on whether you support the ACCDB database
Total Access Admin 2013
If you have the 32-bit versions
of Microsoft Access 2010 or 2013 installed or Access 2007 on
your machine (the free Access runtime versions work), get Total Access Admin 2013. This version supports
the monitoring of:
- Databases in ACCDB format from Microsoft Access 2007,
2010 and 2013
- Microsoft Access/Jet MDB databases from MS Access 97,
2000, 2002, 2003, 2007, 2010 and 2013
Total Access Admin 2013 runs on 32 and 64-bit operating
systems and can monitor databases connected by users using
the 64-bit version of Access 2010 or 2013. Your databases can be under workgroup security and/or have a database password.
Enhancements added in the latest version are
Total Access Admin 2003
If you do not have Microsoft Access 2007 or the 32-bit versions
of Access 2010 or 2013
installed on your machine, get Total Access Admin 2003. The 2003
version supports MDB databases but not ACCDB database formats.