I have an application that is occasionally getting corrupted data in the fields. The table has over 130000 records, but there are only 5 character fields and 1 datetime field. The corrupted records end up with high ascii or null values when there should be data. The application is written in VFP 7, but this also happend in VFP 6. It is run on a Windows XP PC and the data is stored on a Novell server.

This is what I did to fix the problem:
- I looked in the table and saw dozens of records with invalid data.
- Using FoxPro, I copied the contents of the table to a new table with the COPY TO command
- After doing this there were only 2 records that had invalid data in the copied table.
- I deleted the 2 records from the new table.
- I then made a copy of the original table and it's index file using Windows Explorer.
- I renamed the original table and index files, leaving them on the server drive.
- I renamed the copies to the original file names.
- I zapped the table and then appended the records from the new table I created.

These steps corrected the problem. I don't know enough about how operating systems, especially Novell, handle storing files, but there may be some setting or option that can be changed to prevent these errors.

Has anyone had any similar problems, and if so what could be changed to prevent this form recurring? This seems to happen every few weeks with no pattern.

Thanks,