>Hope someone can help with this one.....
>
>I have an application that runs a batch file to transfer invoice batch records from our AS/400 via Client Access. It runs through a loop of transferring the current batch data (6 file transfers), clearing the invoice tables, appending from the text files and processing the records. At the end of the batch file it writes a small text file to let me know the file transfers have completed before it continues to clear and process the records. This has been working without problems for quite some time.
>
>The executable is invoked on the user's local machine but runs the file transfers from the server (which is a mapped drive). We started getting sporadic "1104-error reading file" errors a few months back and they are now happening daily. It doesn't seem to matter how many records the user is transferring and we never know which user it's going to happen to. Once the user reboots they usually have no problem bringing all those same batches down again.
>
>As a side note, there is another foxpro app they usually have open that allows the user to make billing decisions on the invoice batch. This does not use any of the tables that are used in the transfer process but does use the mapped drive to read common files such as customer and tax master. Once the transfer program gets the 1104 error they also start getting errors on that mapped drive in this other program and have to shut it down as well.
>
>I've talked to our Server Admin guys but they say nothing's changed on the server and say it's a Foxpro problem.
>
>The code that is causing this is the 'delete all' statement (tried changing it from 'Zap' as that was the initial code) that clear the tables before the append. Pretty straight forward code. My error routine shows me that the file that I'm clearing is in use and is open exclusively yet I get the error.
>
>Anyone have any suggestions???

I would use CREATE CURSOR instead of either ZAP or DELETE ALL/PACK. Your current process relies on an existing DBF. If that's corrupt, it will trip your process up before it even starts.