Gerard,

Check Re: Database object is being used by someone else. - ERROR Message #671372 and http://fox.wikis.com/wc.dll?Wiki~CreatingDBCforViews

>I am getting a very intermittent error. This happens about twice a day on a busy site (about 6 users).
>..Error loading File..record no 26..MyForm .or one of its members. loading form or the data environment..FILE IS IN USE BY ANOTHR USER
>
>The command line that generates the rror is the Dblclick event of a Listbox and the code is:
>Do Form MYFORM with Param1,Param2,Param3
>
>Myform is a Private Data session form. In its Load Event it has code like:
> Create Cursor Trn ........
>
>I would'nt have thought there was a problem with this code as a new Cursor should be created each time..or maybe the problem is elsewhere...
>
>This is really baffling,particlarly because its so intermittent...It is happening however on a no. of different sites..
>