Total Visual Agent
Product Tour
Microsoft Access/Jet databases require routine maintenance to ensure reliability, integrity, and efficiency. When you compact a database, Total Visual Agent invokes the Microsoft Jet Engine to:
With the Compact Action, you can either compact onto a different file name/directory, or compact onto the same file name. If you choose to compact the database onto a different file name.
Unfortunately, you cannot compact and repair a database while it is in use, since performing these Actions requires exclusive access to the database. Scheduling Total Visual Agent Events during off-hours lets you perform these maintenance chores when users are not likely to have the database open.