Ken,

The process of creating the cursor looks ok. Do you know exactly which table trips the "file access denied?"

"Once completed, I then have another routine which updates the affected tables. Using these created tables, I then process my report form."

What happens in the routines which those two sentences describe? Do any of them SELECT into a table?

If it's the report, the advice to copy it to your temp folder is a good idea.




>Set exclusive is set to off.
>TMP files are sent to c:\fptemp. (yes, \fptemp is an actual directory.)
>
>Cursors are created with the following code:
>
>
>*** Create cust_curs routine - result will only be ONE record
>mkey = customer.key
>
>sele *,recno() as recno ;
> from customer ;
> into curs temp_curs ;
> where customer.key = mkey
>
>sele customer
>use
>
>sele temp_curs
>=afields(atmp)
>mdbf = dbf()
>crea curs cust_curs from array atmp
>sele cust_curs
>append from (mdbf)
>sele temp_curs
>use
>sele cust_curs
>go top
>
>******* END ROUTINE
>
>I have several database that are created this way. All data processing and manipulation is used on the created cursors.
>Once completed, I then have another routine which updates the affected tables.
>
>Using these crated tables, I then process my report form.
>
>Several times a day one of the users will receive the error "File Access Denied" while trying to run the report (invoice).
>