>Hello,
>
> I made a client server program. It uses VB 5 for the client program, ODBC, and VFP 5. After a few months, some .FPT and .CDX files were corrupted and truncated to only a few kilobytes. What may have caused this? How could I trace the problem? Any ideas will be appreciated.
>
>Thanks

Check out article Avoiding Table and Index Corruption at http://64.252.14.73/Articles/kb005.htm