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

Thanks Tushar--I'll play around with that!

Terry