Hi Hilmar, I read your interesting article some time ago, but I was tinking on a 3rd party product, tested and trusted in many conditions and with other capabilities such us rollback and forward, so that I don't have to code them.
Gracias,
Javier.
>>Hi, I'm looking for and audit third party add-on to my VFP application.
>>I know of FoxAudit, ...
>
>As an alternative, if you want to build your own, see my article at
http://www.utmag.com/wconnect/wc.dll?9,7,10,1476 to get you started. (Also available in Spanish.)
>
>> ... but before I start digging deeper I would like to know of experiences of other developers with this package or another ones. I'm particulary concerned about audit tables growing too much in size.
>
>The main problem here is automated processes, which might modify thousands of records for a single user action. If all those changes get recorded, your audit trail might indeed grow quickly.
>
>I moved the audit data to historical tables regularly, mainly to keep my daily backup small. With 10-15 users, and a system with some 70 tables, it would have taken 1-2 years to reach the VFP limit of 2 GB per file - so that was not my immediate problem.
>
>Saludos,
>
>Hilmar.