I am using vfp 7.0. I am porting a fpw 2.6 app and trying to touch it as little as possible. The original app is using a dbf table called layoff.dbf and setting a relation into it so that navigating in a different work area moves the pointer in the layoff work area. That layoff.dbf table is obsolete and I have created a remove view called layoffs.

CREATE SQL VIEW "Layoffs" ;
REMOTE CONNECT "JobMachine" ;
AS SELECT * FROM hr_actions..Layoffs Layoffs

I have set the primary key, but I do not allow any updates. (It would be bad if the users of this app were to change the layoffs table.)

I USE the view and then create an idx file (or cdx doesn't matter) in the user's temp folder so the relation may be set.

indexFile = GETENV('temp') + '\Layoff_' + ID() +'.idx'
INDEX ON lname TO indexFile
...

When I run this app from the IDE, it works fine. When I compile it into a Win32 exe, I get the "Cannot update the cursor" error saying I am trying to write to a read-only file when it tries to create the index file.

How can I get this to work? What file is read only for the exe and not for the IDE? All other settings SEEM to be the same.

Thanks,
Cheryl