The most common case that I've seen is when a prior SELECT-SQL on that table (and involving no others) actually "returns" a "filtered result set" (which, of course, is not a 'return' at all).

To me the best way to overcome this is to employ the NOFILTER clause, available since VFP7. Alternately, I suppose that closing the result-set cursor 'name' would accomplish the same thing.

cheers

>This is probably a fairly basic level question, but here goes...
>
>Occasionally I will encounter a situation where the Used() function will return .f. for a table/cursor being in use, but attemting to then use the tested table fails with a "file is in use" error. The problem is intermittent.
>
>What would cause this to occur?
>
>TIA,
>Margaret