Jim,
'Adjust' does not mean here 'repaired'; recors may be lost if file contains more records than count in the header.
>Yuri,
>
>Have you read something that confirms that VFP6 and VFP7 adjust the header (to prevent loss of data I would presume)?... MSKB #
Q293638 strongly implies that it doesn't so that, in non-TRANSACTION writes, some record (at least 1) got lost somewhere.
>
>
>>I believe, the file is OK and you should not do anything with it. It may not contain the file end mark. Check out the very last character: it should be chr(26) if it is the end mark.
>>
>>Actually you need to repair the file if you cannot open the table getting "NOT a table" error. As a rule it indicates that the number of records in the header is not correct, and in this case you need to replace this number in the header. AFAIK, VFP versions 6 and 7 usually do not display the error and adjust the header automatically with the subsequent table updates. VFP8 does not do it.
>>
>>
>>>Hi,
>>>OK. I have check the the other table. I found that it missing 1 byte only happen to aparticular file. The file still can be open, insert/update without problem. So, How to repair it? I try pack, zap, modi structure, recreate the table using AFIELD() and CREATE TABLE FROM ARRAY also the same.