I have found that VFP will continue on with the code even though the new dbf may not be closed (disk activity).
Try using
on error - call proc that simply returns .T.
DO while .T.
Use tmp.dbf in 0
If used('tmp')
EXIT
endif
enddo
on error