>>I have not had a single problem of corruption with same project on sql 2005. but the VFP databases keep getting corrupted when accidental power loss occurs and the ups too is faulty.
>>Please lets call a spade a spade.
>
>Try using buffering (optimistic/5) on your tables. All tables, at all times. Save all (or nothing) in a loop.
>using Tableupdate / TableRevert. Wrap it all up inside transaction band (begin tran / end tran)
>for keeping data integrity, and you might see some drastic improvements in this respect.
>
>I can't even remember last time I saw corrupted dbf. Excluding SCX, FRX and PJX-es of course. These get corrupted occasionally.

I used even flush force and unfortunately seeing corruption yet...