I'm wondering if anyone from MS can jump into this thread. I can send my program code & GenDBC program, if needed.

Both program do intensive data manipulation...

>I copied data from production backup to my local drive. Every time I'm trying to do either ProcessNewTrans or LoadNewTrans on a big file I get this error when I run the process the second time. I'm using private datasession (session class), Delete ON, tablevalidate = 7
>
>>>I got it again even with SET EXCLUSIVE OFF on replace mNotes with m.lcString in Load_Trans command.
>>>
>>>I'll get new copy of data and will resume my tests.
>>
>>Naomi - I had that a long time ago - I forget what I did, but, try this,
>>
>>1) open your DBF
>>2) delete all the tags (delete tag (mytagname))
>>3) SORT on the primary or most used look up field or fields to a temp dbf (set dele on so deleted records will be ignored) - make your physical order your primary order.
>>4) ZAP your "permant" DBF
>>5) APpend your tmp dbf to it
>>6) index each tag
>>
>>Is it a local DBF - or on a server someplace?