>Vin,
>
>Can you post the code?


There are a few spots where it is happening. They are all remarkable straightforward. Here's one:

SELECT D.lname, ;
D.fname, ;
D.dob, ;
ROUND(S.score,2) AS RndScr ;
FROM st_score S, st_demo D ;
WHERE S.stdid = D.stdid ;
AND NOT EMPTY(S.score) ;
INTO CURSOR C_TotScr NOFILTER

INDEX ON lname + fname TAG name && error here

There's nothing special about the underlying tables (st_score and st_demo). The result set varies, but we have duplicated it with just a dozen or so records.

Very strange. These lines of code were written months ago and, again, work on some of the machines just fine.

-------------------------------------------------------------------------
>>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? It is driving me a little crazy. (Upgrading to 7.0 is a last resort, so I am looking for something else -- IT department at this client is very slow to allow upgrades, as a matter of policy).
>>
>>TIA,
>>
>>Vin
>