> Hi
>
> We are currently having an issue with a client database that keeps both losing data and getting black entries on certain tables.
>
> We have an Options table which stores all of the system wide settings for our application. For this client their options table is being cleared and all settings are being lost. We also have a Members table which stores all of the user information that is getting black users added to it.
>
> Using Gfix, we have run a validate on the database which didn't show any errors. We then tried a Mend followed by a Backup and Restore to see if this would prevent the issue. However only 10mins after performing these steps the options table was blank again.
>
> Any suggestions as to what may be the cause would be greatly appreciated.
>
> Regards
>
> Tim Wilson.
>
>

I think is a problem with the application. Why not create a log table with fields for table, user, timestamp, change type and also create triggers in the tables that you have problems, and when records are inserted, updated or deleted insert records in that log table.

Jesus

>
>

[Non-text portions of this message have been removed]