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