>Dear All,
>
>1. A server with VFP 8.0 DBC tables crashes.
>2. One specific table cannot be opened anymore ("Table is corrupted, it must be repaired before it can be opened again...") in VFP 8.0 nor in VFP 9.0.
>3. We run FoxFix 4 on the table but that gives no file error!
>4. We can open the file in VFP 7.0
>5. We open the file in VFP 7.0 and copy the file (COPY TO ... CDX) to a new named table.
>6. We now can open the new table in VFP 8.0 or 9.0 without problems, no data loss.
>
>Can anyone makes sense out of this?
>Does FoxFix 5 solves the problem of the table being corrupted and not giving an corruption error in FoxFix?
>
>Thanks,
>
>Koos Veel.
You can also issue SET TABLEVALIDATE TO 0 prior to opening the table. If that continues to give you a problem, try appending a blank record and then deleting it and pack the table. This will fix up the record count in the table header.
Carsten M. Thode