>>>Hi,
>>>
>>>A customer says that every so often they get an error message 108 File is in use by another user. I suspect that the server where data reside could be causing the problem. Maybe, another user on another application is attempting to read or write. I don't know. But I was thinking to set a timing loop when USEing (opening) a table to allow for, say, 5 or 10 seconds. Currently, my code simply attempts to open a table once and if it fails, reports a problem.
>>>
>>>Is it a good design practice to allow some time for a table to be opened?
>>
>>SET REPROCESS and related commands were designed to handle this.
>
>Excellent suggestion. I think I will set mine SET REPROCESS TO 5.
>
>Thank you very much!

It's 5 attempts not 5 seconds. I don't think it'll make much difference.