>How can an error File is in use by another user generated from an INSERT INTO command?
>
>This is a line being executed 200 times per day for months and today I found this in the log.

I think INSERT INTO still has to lock the header momentarily while it updates the record counter. More than one INSERT INTO by users in multitask can create the error.