>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 don't know why it would show up after so long, but could it be that buffering/indexing problem I've run into before, where an appended record locks part of the index, and doesn't release it until the record pointer is explicitly moved? (GOTO RECNO())