>>>Hi all,
>>>
>>>I have a VFP5 system that runs on an NT server with more than 100 users. Occassionally, say 2-3 times in a month, the system gives the below message:
>>>
>>>"Error Loading file: Record Number 4 CAPF (or one of its members) Loading form or the dataenvironment: File Access is denied"
>>>
>>
>>SET GUESS ON
>>When opeing views, VFP attempts to lock the view record in the DBC very briefly. If another user attempts to access that view in that time frame, it won't be able to and the DE for the form may fail.
>>
>>The error is 1881. You may be able to trap for it (not sure, never tried) and attempt to run the form again.
>>SET GUESS OFF
>>
>>HTH.
>
>Thanks for the 'set guess on'. Pls set it on again:-)
>
>I do not use DBC and has only DBF - will that make any difference?
>
>Is there anything to check on the 'resource file'? Will it's setting have an effect on the network?
>
>If I do not use 'Data Environment' to open/close files and instead individually open/close files, can it improve the chances of error trapping?
>
>Thanks again.
>
>Leo

Since you aren't using a DBC then this obviously isn't your problem and I'm not sure what is.

As for error trapping, I wouldn't opt for the manual manipulation unless absolutely necessary. It is far slower than using the DE. You can add code to the DE's Error event to trap this stuff and it will be self contained. If you add a form-level property and set it in the DE's Error event, you could query this property in the form's Load event and decide whether to continue on or abort the form Load.

HTH.