>Exactly how do you do your reports? Which files are you making read-only? The report (frx) files? Are they included in your project?

Both FRT & FRX are marked Read only. No, I'm not using projects.



>In my apps I either SET EXCLUSIVE OFF or specifically include SHARED when opening a table. My report forms are included in the app. I SELECT the appropriate data INTO CURSOR MyCursor, a cursor being a temp file on the user's hard drive, usually C:\Windows\Temp.
>
>I'm wondering if you are SELECTING ... INTO TABLE MyTable and the table is on the network in the directory where the data resides, so the first person there hogs the table until they're done with the report.
>

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).


>
>>I have a single report (invoice) in which a dozen or so people need to use. When multiple users try to run the report
>>at the same time they receive a 'file Access Denied' message.
>>
>>I have tried making the files read only (novell server) but does not seem to work.

Thanks for the help.