Does MySQL support triggers?
In Microsoft SQL on important tables we have triggers on update and delete that take the (original if an update) values of the fields in the record and post them to an update_log table that includes the operation done ('UPDATE' or 'DELETE'), the user name, the datetime the operation was done, and all the rest of the fields in the record.
These tables are pruned as part of the database maintenance plan based on age of the operation_date.
This has been a lifesaver on several occasions after people managed to really screw things up on our MS SQL data.
I think you can do this with VFP databases as well although we no longer use VFP databases or tables for storage.
>Please don't be offended if you already know this, but you may consider taking a similar approach in vfp and remote databases. When a record is deleted by a user, stamp it with a date/time. Then have a purging routine dump or even archive records that are older than x days.
>
>In vfp, I so stamp "deleted" records and then I physically delete and pack them later. This empowers the users to recover things on their own.
____________________________________
Don't Tread on Me
Overthrow the federal government NOW!
____________________________________