Error loading file - record number 18

[amills]

I have a application that is run from server on workstations calling the .exe file. When second user pulls up tries to run form thet get message 'Error loading file - record number 18. CASESEARCH < or one of its members > Parent. File access denied&quot;

Help ???

 

[baltman]

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/err1881.asp

Says:

Error loading file - record number n. &quot;object&quot; <or one of its members>. &quot;Issue&quot;: &quot;error&quot; (Error 1881)
An error occurred while attempting to read in a form (.scx) or class (.vcx) file. Issue relates to either &quot;Properties,&quot; &quot;Methods,&quot; or &quot;User Properties.&quot;

To resolve the error:

To access the record referenced in the error, open the form or class as a table as follows:
USE myform.scx
To move to that record, use the GO command.
You can often find the cause of the error in the Properties, Methods, Class, Classloc, Objname, or Parent fields.

Note You should make a backup copy of your form and class file before modifying the contained records and fields directly.

Brian

 

[amills]

class = formset

baseclass = formset

objectname = CASESEARCH

properties = DataSession = 2
BufferMode = 2
AutoRelease = .F.
Name = &quot;CASESEARCH&quot;

I've tried changing the datasession and buffermode to no avail. I'm not sure what it could be.

Andy

 

[amills]

Never mind the previous reply. I found it. I had a file in the data environment set to exclusive use....duuuughh.

Thanks for your help.

Andy

 

[baltman]

The fact that it happens with a 2nd user makes me think that you have a share problem. Does the form create a record lock?

If the record lock is just fleeting you can increase the SET REPROCESS TO settings; if it is persistient you'd need to re-code.

Personally, I copy a current version of needed data to a user's local PC for modification and updates and then update the network DBFs with DELETE FOR to remove the records that were changed and APPEND FROM to add the changed and new records while in use SHARED and then PACK the network's DBFs only once and a while to purge the deleted records without denying access to user's applications on a regular basis.

Brian