>>>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 ?
Not sure -
(1) bit 0 does not apply in my opinion
(2) bit 1 is likely to reduce the time of inserting/appending
(3) bit 2 does not apply in my opinion since the table is already open
(4) bit 3 : see bit 1
Gregory