>>>We're facing the urgent need of a tool that can track any change made to any table in our VFP database application for production tracking. some points you should know if that, there are some tables which are quite big, like for example one with 1,4GB or so.
>>>
>>>now what i am looking for is a tool that can add changes auditing to my databases with the minor effort in programmming, looking for something that doesn't impact that much in performance.
>>>
>>>what i am not looking for is advice in how to reduce those big tables, or how to improve our aplications code, at least not in this thread.
>>>
>>>I've being thinking about FoxAudit from TakeNote. but in the site they doesn't give much information
>>>also i haven't being able to get any comments or rating about this product. so i wonder if somebody of you is using this tool and any feedback about it.
>>>
>>>is there any other tool to achive this?
>>>
>>>TIA
>>
>>I've used foxaudit with great success. It works primarly off triggers and is quite easy to implement.
>
>how about performance?

I've been satisfied with the performance. The only *possible* thing that could lead to a problem is the size of the audit table. Obvisouly the more updates made to the data, the bigger the table gets. I simply archive the table once in a while to insure it never gets to the infamous foxpro 2gig limit.