As Matthew wrote, use Tablevalidate. The reaason why you see this, is that VFP9 does more error checking, meaning that you may have had data corruption for a long time, without knowing it. VFP9 will let you know so you can fix it.
>I do a lot of automated reporting using Cognos Impromptu v7.3, where the query results are exported to a DBF. FoxPro then generates a formatted Excel spreadsheet, prior to emailing the file as an attachment. I'm in the process of migrating my applications from VFP 7.0 SP1 to 9.0 SP2.
>
>VFP 9.0 is unable to open the DBF generated by Cognos Impromptu. The error it reports is "Table [name] as become corrupted. The table will need to be repaired before using again." The description of the error says that "Either the table record count does not match the actual records in the table, or the file size on the disk does not match the expected file size from the table header."
>
>However, VFP 7.0 has no trouble opening the DBF, and this is the first time I have encountered this problem.
>
>Have the table specifications changed after VFP 7.0? It appears that VFP 9.0 has a stricter specification, or Cognos Impromptu 7.3 is not compatible with VFP 9.0.
>
>---Michael