I had one instance recently where the same tag in the same CDX was getting corrupted on a semi-regular basis. Tracy's comment about the Windows Indexing service was another thing I hadn't thought of. I may have to add that to the list. Having said that, I had the client's IT guys add the appropriate registry keys for disabling the oplocks/write caching and it's been stable since then.

--

rk

-----Original Message-----

From: profoxtech-bounces@leafe.com [mailto:profoxtech-bounces@leafe.com] On Behalf Of MB Software Solutions, LLC

Sent: Tuesday, September 06, 2011 3:40 PM

To: profoxtech@leafe.com

Subject: Re: VFP9SP2 - Error 2066: Index file "z:\data\costs.cdx" tag "Njobid" iscorrupted. Please rebuild it.

I do notice that it fails constantly on the Costs table. That's the only table where I do a ZAP in my code. Coincidence? I don't think so!

You other guys who got this 2066 (or funky 108 or 1104 errors)...was it always on the same table, and do you ZAP that table in your code????

Sounds like a clue.

_______________________________________________

Post Messages to: ProFox@leafe.com

Subscription Maintenance: http://leafe.com/mailman/listinfo/profox

OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech

Searchable Archive: http://leafe.com/archives/search/profox

This message: http://leafe.com/archives/byMID/profox/DF1EEF11E586A64FB54A97F22A8BD04419F2A66C95@ACKBWDDQH1.artfact.local

** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.