I ran your test under VFP6 SP5 and VFP7 SP1 on Win2K SP2 for 10 minutes each w/o any problems. What is your configuration/environment? What ODBC driver version? On my PC it's 6.01.8629.01

>Well we have sorted it out... sort of.
>
>We believe we have found a bug in VFP and the only workaround so far we have found is to put an index on the nTableID column. Attached is a link to a ZIP file containing a test case that demonstrates this problem.
>
>Does anybody know if this is a known bug or if it has been declared not a bug or something. Maybe someone from the Fox team could comment on this ?
>
>Link to file: DataProbTest.zip
>
>Cheers,
>
>Chris Ormerod