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