Can't seem to pinpoint cause of this error... hoping someone here can help.
I have an automated VFP9 app that converts xml email attachments into temporary tables and inserts records into FPD2.6 tables.

Of the 9000+ records it successfully created, intermittently I get an error emailed to me like this:
Error number : 108
Error message : File is in use by another user.
Line causing error : newid("volchgpro")
Line number of error: 63
Program with error : AWORK9

The actual line causing the error is: INSERT INTO DETAIL FROM MEMVAR. This is an INSERT into a FPD2.6 table. The 'newid("volchgpro")' above refers to a stored procedure that gets a unique id number for a table called volchgpro that is not involved with the INSERT at all. Why is this error occurring?

Extra info if this helps:
FPD2.6 app is used by several users for Order Entry.
VFP6 app is used to make adjustments/corrections to above FPD2.6 orders.
VFP9 app is used to automatically add records to above FPD2.6 orders.

Regards,
Ed Pecyna