Doug,
thanks for the help. The header should be ok. Our reindex prg checks the header against the file length and fixes it if there is a problem after backing the file up. It then packs the file before deleting all index tags and creating new ones. The DBC is packed before all this happens. I'm trying to see if anyone has ever seen a DBC problem cause table update problems. The Validate Database returns no errors. I am thinking of writing a prg to create a new DBC as part of the update but don't want to do it unless there is some chance it will fix the problem.
John.
>Hi John.
>
>> The problem happens when new records are added.
>
>This likely isn't a DBC problem but a table header corruption problem. There's a known bug in VFP that causes records to be incorrectly added to a table (usually by overwriting an existing record) when the record count in the table header is incorrect. Simply PACKing the table will resolve the problem.
>
>Doug
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn