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.
When using Total Visual Agent I get an error saying "Unable to compact replicated databases," but my database is not replicated.
This issue can occur for a number of reasons.
- Your database is read-only.
To resolve this, use Windows Explorer to locate the database in question. Right click on the database, and choose the menu selection "Properties." Ensure that "Read-Only" is not checked.
- You have either a database password, or a user ID & password that is not specified in the Database Settings.
To specify these settings, go to View, Managed Databases (in the Total Visual Agent Manager). Then, highlight your database, and choose the Edit button. The "Use Global Default" setting will allow you to set the database password. The "Specify Workgroup" setting will allow you to specify the user ID & password. Please keep in mind that with this setting you must specify an .MDW.
- This is not a valid Microsoft Access database.
If this file is not an actual Microsoft Access database, but has the .mdb extension, this error can occur. To ensure that it is a Microsoft Access database, please try opening the .mdb with your version of Microsoft Access. If an error is returned saying "Unrecognized database format", then the database was either created with a newer version of Microsoft Access than what you have installed, or it is not a Microsoft Access database at all.
- The database you are trying to run the compact action on is a replicated database. Please note that Total Visual Agent will not perform this action on replicated databases.