>>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
>
>
>Append blank locks the table header during the append
>
>Following link says that this error can occur when two users append a record at the same time
>
>
http://msdn.microsoft.com/en-us/library/aa975797(VS.71).aspx>
>Users can share the table without causing a conflict when you issue the APPEND BLANK command, but an error can occur while another user is also appending a BLANK record to the table. You can trap for the error, "File is in use by another," which is returned when two or more users execute APPEND BLANK simultaneously.
>
>
>It's not clear to me how much 'set multilocks on'/set reprocess to / sys(3051) can help. Maybe a simple retry will do
>
>
>
>
What do you think about setting TABLEVALIDATE to 0 ?