Hi Tore

yes I usually you INSERT INTO.

This is an old system and I'm trying to change as little code as possible.

I may replace all the APPEND BLANKS.



>I suggest that you don't use APPEND BLANK. Instead I recommend INSERT INTO which is must faster and more reliable. Plus it's much easier to upgrade to a real SQL server.
>
>>Hi
>>
>>I've just picked up this error in a multi user system
>>
>>File is in use by another user
>>
>>But I am puzzled as the file is already in use by the application and the error is occurring on the line APPEND BLANK.
>>
>>Any ideas why I would get that error?
>>
>>Thanks
>>
>>Nick