>One of our clients has a corrupted table. I have FoxFix, but either it's not working or I don't know how to use it. It looks to me that the data is shifted and I'm getting a whole lot of "delete flag corruption" errors, but I don't know how to fix it. Can anyone help me??
>Thanks,
>Elyse

1. What version of Fox?
2. How big is the DBF at the moment (in bytes), do you have any way of knowing how big it should be?
3. Does it contain sensitive data?
4. Are there any memo fields?
5. Is it a free table or referenced by a DBC?
6. Do you have details of any index Tags stored elsewhere?

If it's small'ish (zips down to a few meg) and does not contain sensitive data - then you could send it to me and I'll see if I can fix it.

Rolling your own recovery tool (not meant to be comprehensive):
Text fields are the easiest to recover - most other data types require work to read/convert to text.
Copy the table and change the extension to .TXT
Open the text file using Notepad (if it's not too big) or Modify File in Fox - how does it look.
Delete the file header and save.
Use low level file I/O to copy the text file into another new text file, this time inserting chr(9) as the field delimiter and chr(13) as the row delimiter.
Create a new temporary table and append the text file into it.