>Hey folks. I am running into a strange and intermittent problem at a client -- frequent on some machines, infrequent (or not present) on others. When I SELECT into a cursor (or even create a R/W cursor) and then index the cursor, I (sometimes) receive a File Access denied error.
>
>All of these workstations have VFP 6.0 SP5. Some are running NT Workstations, some are running 2000. All code is located on local drives. If I try keep resetting to the same line in the debugger, after one-three tries it works and moves on (fun!!).
>
>-- This is not a case of a filtered view -- if I use NOFILTER it still happens.
>-- It is not a case where there are not adequate rights on the temp directory -- there are indeed full rights.
>-- It is not a case where the index has a call to another procedure or function, which is erroring out and passing the error up.
>
>Any other thoughts?

This phantom is around since 2.0 or so - most of the time you can index a cursor any way you like, but sometimes you just can't.

The way around is to use a nondefault name for the .cdx file:

cCdx=[ your favorite temp file name generator here]
Index on cThis+cThat tag Name1 <b>of (cCdx)</b>

And that's it. The index will get deleted when the cursor is closed, at least now that I tried (in VFP7) - I seem to recall this was a problem in some previous versions.