> I import 30+ files from an old DOS Business Basic system every day and convert them to VFP files.
> At the end of the import I have a 'wrapup' program to handle little details as I prepare to install the final system.
> After months of no problems, in the last week I've gotten two 'file access denied' errors in this last program.
> The program runs on 5 different standalone computers as people update from the files on a daily floppy disk.
> Two errors, each involving different files. No DE, no buffering, just a simple PRG.
>
> Here's the code for one of the errors.
>
>

> IF !USED('invproduction')
> 	USE invproduction IN 0
> ENDIF
> SELECT invproduction
> REPLACE ALL lbooked_prod WITH .t.
> REPLACE ALL drec_activity WITH dprod_dt
> USE

> |
> | other code, other files
> |
>

SELECT distinct dprod_dt FROM invproduction INTO CURSOR crdt ORDER BY dprod_dt

> produces error (once)
>
> Is this perhaps some kind of timing issue? Should I issue periodic FLUSHes in the code?
> I can't reproduce the error, so it's hard to know the best approach!
>
>
> Terry

Try by using UPDATE instead of REPLACE. The command will be

UPDATE invproduction SET lbooked_prod=.T.,drec_activity=dprod_dt

Regards
Tushar