The INSERT INTO command locks table header shortly to add new record. If another user already has table header locked than you'll get that error.
>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
--sb--