Not a charity case, but this client is through an agency and my time is the only thing that gets billed. I will get FoxAudit for my own contract work - it looks like it does a great job - but not for this one. In the meantime, do you have any ideas how I begin tracking record transactions at the database level? Doesn't need a lot of bells and whistles, just enough to be able to review what changes were done. Thanks!

You're selling yourself short; I know your work and you're worth much more than $.02 for the last reply... Mmmm...unless you meant me! ;-)


>Renoir,
>
>$259 vs. how much of your time? If the client is not a charity case, surely you can bill it out at your hourly rate. To plagiarize a bit, a waste of a perfectly good programmer's time.
>
>$.02 (Only $258.98 to go :o)
>
>>>>I've taken over a Visual 5 app that was converted from an old DOS 2.6 program. I need to be able to keep a table of any changes made during record edit. The previous developers held onto some of the logic that checked each field against its previous value to determine if a change had been made; I would like to handle this some other way. I'm considering doing something at the table level, but am unsure exactly where to begin. I searched through past threads and using triggers seems to be one option. Any ideas? Thanks!
>>>>
>>>>Regards, Renoir
>>>
>>>Check out FoxAudit class at http://www.takenote.com/foxaudit.htm
>>
>>That sounds awesome, but the client I'm doing this for is part of state government and $259 might as well be a million. I may get that for my own work, but for this application I would have to donate it to them, and enough of my income goes there way already... Anyone have other less slick-and-costly solutions? Renoir