Access Autopilot will save you hours of time and frustration by ensuring critical backup, compact and archive operations are automatically scheduled overnight. But more than just an automated compact utility, it's a total access database 'back-end' administration control center.
Need to compact the database or bring it down for maintenance? Autopilot will reveal which users and computers are connected to the database then allow you to send a custom admin pop-up message direct to their machines i.e. 'Please exit the application!'.
Running as a Windows service for reliability, this server based tool will manage an unlimited number of access databases spread across your organization. Perfect for taking control of all those pesky Microsoft Access databases, managing them from one central, convenient location. Set and forget an unlimited number of maintenance jobs for each database profile, your own centralized 'database of databases!'.
Best Backup (R) technology determines if users are in your database, then chooses the best method of backup including extracting table data out to an external database. This creates a reliable, date archived, corrupt free copy of your database tables if you need them.
No need to have users exit the application before backing up tables. Flexible naming conventions for archived backups, such as dates, incrementing numbers or backup sets. Never be confused about the origin of a backup!
Other useful features includes quick database statistics on the back end such as identifying record counts, last compact and backup dates, database size etc. Monitor database stats from the server to identify bottlenecks.
Access Autopilot will even run a custom macro in your database, to perform more advanced tasks such as purging or archiving historic records, or even executing another application. Essential for network administrators, database administrators and access developers using Access in a multi-user environment.