>Yes, but when this occurs in VFP and does not generate an error it leads to data corruption and/or missing records. I have a way to fix the problem in both FoxPro and VFP when I know it is present but VFP's not informing me by way of an error is the problem.
Actually, VFP (in either 6.0 or 7.0) doesn't utilize the value contained in the header to return the correct number of records through RECCOUNT(). The only realiable way to make sure the number of records match is to actually retrieve the value from the header via low-level file I/O and, then compare it to RECCOUNT().
There really isn't much of a problem if the number of records in the header is greater than actual. Simply adding a record, then deleting and packing will fix it. The real problem is if this number is too low. It must be properly adjusted. If it isn't and the file is PACKed, you'll lose records.
The positive side to this is at least now, you have a method of checking for the problem and making the correction yourself. If you had error 15 back, you wouldn't be able to open the table, and thus have no way to fix (outside of a third party product).
George
Ubi caritas et amor, deus ibi est