Mallari,

> Is anyone seen any table curruption problem in VFP like there are problems in FPD2.6 of 'Not a database file'. And if VFP table file gets currupt, is there any tool to recover it?

That particular error is usually related to the table header having a record count that is different from the actual number of records in the table. That can happen in either FPD2.6 or VFP, often when someone turns off the computer during updating of a file, the power goes off, or if the network goes crazy, etc.

You can use commercially available tools such as SDT to recover, or you can go into the header record and change the record count (be careful). Often the count just needs to be decreased by 1, but not always. This can be done with a hex editor, or with low-level file i/o.

The header bytes in question are 4-7, if counting the first byte as 0 (same for 2.6 and VFP). Usually byte 4 is the one to change, since it is the Least Significant Byte (LSB) or the first pair.

The appendix of the Programmer's Guide contains the File Structure of a table.