>Hi all, I am getting the following error on an END TRANSACTION. This did not occur in our app until we upgraded from VFP 6 to VFP 9.
>
>Error: Table "C:\DOCUME~1\michaelv\LOCALS~1\Temp\00006Y2X001I.TMP" has a file length / record count inconsistency. The table will need to be repaired before transactions can be committed properly. (2065)
>
>I do notice that this file does not exist at the time of the error, but have not pinpointed when this file get's created/deleted. I am not all that familiar with these .tmp files.
>
>Any suggestions? Thanks in advance.
>
>Mike
SET TABLEVALIDATE TO 1