>>
>>The error generation is EXACTLY what I want to avoid. That is why I asked if there was an equivalent to RLOCK(0) to manually lock the header - this returns false if it cannot lock - then you just loop until you can lock it.
>
>Nigel,
>
>When error 108 occurs, I just trap the error and execute a RETRY command until the original INSERT INTO command is successful. That seems almost the same as retrying a RLOCK(0) until you can lock it. If I am missing your point, I am sorry, I just want to help.
Sam,
Our existing system which is having this problem already has any number of error traps - I have taken this system over and want to avoid using ON ERROR as, at the point of error, we don't know what the current error trap may be. We have had some brainstorming sessions on this and came up with nothing!