and Schedule Repetitive Microsoft Access and Jet Engine Database Chores!
Are you performing the database maintenance tasks Microsoft Access
requires on a regular basis?
FOR MICROSOFT OFFICE ACCESS
- Supports Access ACCDB database formats
- Additional tasks that can be run under an NT Service
- Improved support for ADPs
sleek, more modern user interface
- A new 108 page user manual
Microsoft® Access® Jet Databases (MDB and ACCDB formats) need to be
periodically compacted and repaired for optimal performance (for more
info, visit the Microsoft site for
keeping Jet databases in top condition). You should also make
regular backups, and multiple backups for disaster recovery.
Unfortunately, these critical tasks are often neglected until disaster
Don't let that happen to you!
Schedule It and Forget It!
Total Visual Agent lets you easily schedule and execute the
repetitive tasks your databases need. Schedule a wide range of tasks and
run them in a fully automated and audited manner. Set start times and
end times, and receive emails if anything goes wrong. For extra
security, Total Visual Agent can run as an NT Service, so it can run
without a user and recover from crashes.
Total Visual Agent is a
system administrator's dream! (PC Week)
Easily setup and manage events, tasks, databases, and folders:
What Total Visual Agent Does for You
- Do you neglect maintenance tasks that are important
for keeping your databases healthy?
- Are you tired of spending every Monday or the first
of the month manually running Access reports or macros?
Wouldn't it be nice if the reports were just waiting for you when
you showed up at work?
- Do you forget to run end of day routines to send
information or download data for the next day?
- Would you like an easy to use system to run your
tasks on a schedule?
If so, you need Total Visual Agent. Total Visual Agent lets you define and schedule these tasks for a
specific database or a drive/folder full of databases:
- Database compact and repair
- Database copy and zip backups
- Macro Scheduler: Launch
Access and run your macro which can do things like print
reports, download data, export information, and run your custom VBA code
- Data extraction while users are in the database
- Collect database statistics like record counts to
- Run any
Windows command line
Define Your Own Schedules
Total Visual Agent
lets you schedule and automatically perform these tasks multiple
times per hour, once per hour,
daily, weekly, monthly, or at a specific time in the future. Perform
your daily chores in the middle of the night! You can even back up data
while users are in the database (ideal for 24/7 environments) or
execute your own custom code such as printing reports or data
uploads and downloads.
Manage an Unlimited Number of Databases
Total Visual Agent manages an unlimited number of
Access/Jet Engine databases across your network. Install
it on a PC that can see the databases you want to manage. It can
even run as an NT Service to provide extra security and
automatically restart if your PC goes down.
The administrative portion lets you specify your events:
hourly, daily, weekly, monthly, or one time events
optional end time if you want to stop the tasks by a certain time.
For instance, to make sure all the backups are done by 5 AM. If the
deadline is hit, an email notifies you so you can adjust your tasks
Define the tasks to execute:
- Select a
database and the tasks to perform on it
- Specify a
drive letter or folder and the tasks to perform on all the
databases there (including sub-directories)
- Create a
Task Group (a set of tasks you want to perform) and assign the
databases or folders you want the tasks applied. This makes it
easy to change the set of tasks you want to apply against multiple
When the time
arrives, Total Visual Agent performs its tasks, then goes back to "sleep" to await
the next event.
Total Visual Agent supports secured databases and
lets you assign the security workgroups, user name, and passwords
necessary to perform the tasks you need.
Audit Trail and Email Notification of Problems
Total Visual Agent offers a professional solution to
ensure your Access/Jet databases perform optimally and are
administered properly over time.
A complete audit trail is
maintained in a table for every task performed. If an error occurs, an
email is automatically sent to alert the system administrator. System
administrators will also appreciate the ability to specify a cut-off
time for tasks be completed. This ensures that as your databases grow
and your tasks require more time to complete, Total Visual Agent never
interferes with your business needs and alerts you if it runs out of
time to finish.
Runs as a Windows NT Service
Total Visual Agent can run as a standard Windows program
or as a "hidden" Windows NT Service. The service runs even without a
user logged on to the computer, providing increased security and
automated restart if the machine crashes. Simply schedule the tasks you
want, and let Total Visual Agent take care of it forever.
Microsoft Access Database Maintenance
So you've successfully deployed your Access database application and people are happily using it.
Don't rest yet! System administrative tasks are just beginning.
Whether your application is written in Access,
VB6, C++, or Visual Studio .NET, if you rely on Access/Jet Engine
(*.MDB or *.ACCDB) databases, you need to periodically compact, repair, backup
(copy or zip), and monitor them to achieve optimal performance,
recover unused disk space, and prevent data corruption. Total Visual
Agent does all of this, plus other scheduled tasks to simplify these
Supports Multiple Versions of Microsoft Access
Total Visual Agent 2007 is our latest version supporting
Access 2007 and all prior Access database formats, plus databases
created by the 32 bit version of Access 2010:
- Access 2007, 2003, 2002, 2000, 97, 95, 2.0, 1.1, and 1.0.
- Jet Databases and Access Data Projects in Access 2007 format or earlier
(ACCDBs, MDBs, ADPs)
- Jet Engine 4.0, 3.5, 3.0, and 2.0
- Visual Basic 6.0, 5.0, and 4.0
Total Visual Agent 2007 requires a copy of Access 2007 to
be installed on the same machine. This can be accomplished by installing
free runtime version of Access 2007, so you don't need to
use a paid license if you want to dedicate a machine for Total Visual
If installing Access 2007 is not an option, Total Visual Agent 2003
is available for supporting all Access database formats from Access 2003
and earlier. For more details, visit our FAQ to
decide which version is right for you.
Microsoft Access 2010 Version Coming Soon
Total Visual Agent 2007 already supports the ACCDB databases common to
Access 2007 and 2010, so you can already perform database tasks on
databases created by Access 2010 (32-bit version).
Total Visual Agent 2010 is under development and coming soon. It
includes direct support for Access 2010's 32 and 64-bit
versions. If you purchase the Access 2007 version, you will receive a free
upgrade to the 2010 version when it ships.