FMS Home FMS Software Development Team Blog FMS Facebook Page FMS Twitter
Jump: Search:

Total Visual Agent

Microsoft Access 2010/2013 Version
is Shipping!

With Windows Service!
Supports: All Access, Jet Engine, and Visual Basic versions


View all FMS products for Microsoft AccessAll Our Microsoft Access Products

Agent Info

 

"Total Visual Agent is a real find, a rare combination of ease of use, and bang for the buck. In the end, no other competitor even comes close."

Thomas Wagner, Product Review in MS Office and VBA Developer

More Rave Reviews

Related Resources

 

 

 
Automated Task Scheduler for Microsoft Access Microsoft Access Database Compact SchedulerSchedule Microsoft Access database tasks for compact, backup, macro run, etc. Microsoft Access Database Insurance: Maintenance and Corruption Prevention

Automate and Schedule Repetitive Microsoft Access and Jet Engine Database Chores!

Microsoft AccessNEW VERSION FOR MICROSOFT ACCESS 2013, 2010 and 2007

New Features:

  • Runs on 32 and 64-bit systems
  • Simplified management of multiple MS Access versions
  • Import settings from multiple installations
  • Test actions for a database, directory, or task group
  • Test all actions for an event
  • Events that can be scheduled every X minutes
  • Events that are limited to periods including midnight
  • Directory processing supports managed databases to support a mix of security settings
  • Data Extract tables are keyed
  • Macros in password protected databases can run unattended
  • Pause for fractional minutes
  • Compressed archive file names for multiple extensions
  • More detailed activity logs with optional deletion
  • Logs with pre and post sizes of compacted databases
  • More detailed database statistics are collected
  • Improved user interface with a more modern fonts, icons, resizable forms, menus, etc.
  • Add comments to events, directories and actions
  • More easily add new actions
  • A new 123 page user manual and help file
  • and more...

Microsoft Access Database Maintenance

So you've successfully deployed your Microsoft Access database application and people are happily using it. Don't rest yet! System administrative tasks are just beginning.

Compact and Repair Microsoft Access DatabasesAre you performing the database maintenance tasks Microsoft Access requires on a regular basis?

Whether your application is written in MS Access, VB6, C++, or Visual Studio .NET, if you rely on Access/Jet Engine (*.ACCDB or *.MDB) databases, you need to periodically compact and repair them for optimal performance, recover unused disk space, and prevent data corruption. For more information, read the Microsoft article on keeping Microsoft Access databases in top condition.

Total Visual Agent automates database compacts, makes backups (copy and zip), runs macros, collects database statistics, and performs other scheduled tasks to simplify these repetitive chores. Make sure these critical tasks are performed before disaster strikes.

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 Windows Service, so it can run without a user and recover from crashes.

Total Visual Agent is a system administrator's dream! (PC Week)

Easily Define and Manage Events, Tasks, Databases and Folders

Microsoft Access Database Task Scheduler with Total Visual Agent

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:

Actions to Perform on Microsoft Access Databases

  • Compress Microsoft Access Database Backup ArchivesArchive backup copies of your databases with the option to compress (zip) them. Keep up to 99 rolling versions of them.
  • Compact and repair your databases
  • Run any Windows command line
  • Collect database statistics like record counts and database size to monitor usage
  • Launch Access and run your macro which can do things like print reports, download data, export information, and run your custom VBA code
  • Create a copy of your critical data for all or specified tables in your database when you don't want or need to copy the entire database

Define Your Own Schedules

Total Visual Agent lets you schedule and automatically perform these tasks every specified number of minutes, once per hour, daily, weekly, monthly, or at a specific time in the future.

Set the Schedule Type to Automate your Microsoft Access database chores

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.

Hourly Schedules
Hourly Schedules: Once Per Hour Options
Every X Minutes Schedule
Hourly Schedules: Every X Minutes Options
Daily Schedules
Daily Schedule Options
Schedule Weekly Microsoft Access Tasks
Weekly Schedule Options
Monthly Schedules
Monthly Schedule Options
Daily Schedules
One Time Schedule Options

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 a Windows Service to provide extra security and automatically restart if your PC goes down.

The Manager portion lets you specify your events:

  • Create hourly, daily, weekly, monthly, or one time events
  • Set the start time
  • Specify an optional end time if you want to stop the tasks by a certain time. For instance, you can 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 and events.

Define the tasks to execute:

  • Select databases and the tasks to perform on them
  • Specify a folder and the tasks to perform on all the databases/files 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 databases.

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.

Activity History Log of Microsoft Access database maintenance

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 also appreciate the ability to specify a cut-off time for tasks to 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.

Run as a Windows Service

Total Visual Agent can run as a standard Windows program or as a "hidden" Windows 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. Visit Run as a Windows Service for details.

Microsoft Component Services for Total Visual Agent

Support Multiple Versions of Microsoft Access

Total Visual Agent 2013 is our latest version supporting MS Access 2013 and all prior Access database formats:

  • Microsoft Access 2013, 2010, 2007, 2003, 2002, 2000, 97, 95, 2.0, 1.1, and 1.0.
  • Jet Databases and Access Data Projects (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 2013 requires a copy of Access 2007 or the 32-bit version of Access 2010 or 2013 to be installed on the same machine. This can be accomplished by installing a free runtime version of Access, so you don't need to use a paid license if you want to dedicate a machine for Total Visual Agent.

If installing one of those Access versions is not an option, Total Visual Agent 2003 is available for supporting all Access database formats from Access 2003 and before. For more details, visit our FAQ to decide which version is right for you.

Total Visual Agent Products
for Microsoft Access, Office, and Visual Basic 6

License Price Access 2013,
2010 and 2007
Access 2003 and Earlier
Visual Basic 6

Single $299 Buy Now Buy Now
5-Seat $899 Buy Now Buy Now

Upgrades

Single $199 Buy Now Buy Now
5-Seat $599 Buy Now Buy Now

Premium Support Subscription

Single $299 More Information
5 Seat $999

Also Available as part of:

Total Access Ultimate Suite
Total VB Enterprise Suite

Runtime/Redistributable Version

A runtime version of Total Visual Agent is not available since it cannot be bundled within an Access or VB6 application (like a control). Total Visual Agent is a system administrative tool and usually runs on a machine separate from the deployed applications. Since it can manage databases across the entire network, its usefulness extends well beyond your application.

Many developers and consultants, who need to bundle scheduled database maintenance with their applications, purchase multi-license copies of Total Visual Agent and resell it to their clients. Not only can you resell Total Visual Agent at full price, you can also charge fees for installation and configuration to manage your applications, all their other Access/Jet databases, and scheduling other tasks. For more information, please contact info@fmsinc.com.

Licensing Information

Total Visual Agent is licensed on a per installation basis. Each installation can manage multiple databases across the entire network (assuming the machine has rights to view the other network drives).
Feedback

Contact Us  l   Web questions: Webmaster   l   Copyright FMS, Inc., Vienna, Virginia
Celebrating our 28th Year of Software Excellence