This patch update is designed for existing installations of Total Access Agent 8.01 through 8.04. It will not install if an existing installation of Agent 8.01 or above is not found. The patch makes a minor change in the way that Agent performs its Compact/Repair operation.
Total Access Agent 8.01 was designed, based on recommendations from Microsoft, to perform the Repair operation after the Compact operation. This can result in the database actually growing larger after Repair than it was after the Compact. The size of the database, when using Agent 8.01 was equivalent to what you would get if you used Access itself to Compact and then Repair a database.
This update changes the behavior back so that the Repair operation is performed first, followed by the Compact operation. The size of the databases compacted by Agent should now be the same size as databases compacted by Access itself when the Repair option is not run.
If this new behavior is not satisfactory, you can control the order in which Agent will Compact and Repair databases by changing a registry setting.
These enhancements were added:
Click here to download: taag805.exe (525 KB)
Alternatively, you might wish to obtain the Jet 3.51 update from Microsoft. This updated component automatically incorporates Repair functionality into the Compact operation. If Agent 8.01 detects that Jet 3.51 is installed, the Repair operation is not performed, and the size of the database after using Agent should be equivalent to the size when using Access's Compact utility.
The Jet update may be obtained at: http://support.microsoft.com/support/kb/articles/q191/7/43.asp
To view an article about this update, search for article Q191743 in Microsoft's Knowledge Base.
If you have Total Access Agent version 1.x installed, you should download this update to get the latest versions of several important files. After downloading the file to a temporary directory, extract the contents and read the UPDATE.TXT file for information on installing the new files.
tagnt107.zip (207 KB)
Patches are for registered users only and subject
to the product licensing terms.
You may not re-distribute them without express written permission from FMS, Inc.
With Windows Service!
Supports: All Access, Jet Engine, and Visual Basic versions
"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