>Hi Stacy.
>
>>problem: table will not accept new records
>>
>>fix: copy table to another location
>> zap and pack the table
>> append records from the copied table
>
>This is a known problem with VFP. As Chris pointed out, the record count is the header is incorrect, so new records aren't properly appended to the end of the table (often, they overwrite the last record so while they're added initially, they're overwritten when you add the next record). TABLEUPDATE() returns .T. so you can't detect this error that way, unfortunately. The fix you outlined works, as does running SDT's Repair method or even Reindex with the pack parameter set to .T., because in essence the table header is rebuilt with a corrected record count.
>
>Doug
Thanks for the tip Doug, I will most certainly use your software from this point forward for these types of fixes. I love using SDT for other uses and now will add this to the list. This does not happen very often, but SDT will handle it - great. I thought that I had tried this a long time ago, but I must not have...
The cause of the corruption turned out to be a bad battery backup on the server at the client site. We had instructed them on how to test, but they did not test properly. The server was re-booting with power surges.
Thanks,
Stacy
Black Mountain Software, Inc.