>
>I think that's just an "old wive's tale"!
>Yes, I'll agree that *IF* the front portion of the .CDX, where the TAG info is kept, gets 'damaged' the REINDEX will not solve anything. BUT... just how often do you think that occurs since, say VFP6? THAT's the main issue.
>I'd say it happens about a frequently as does any file getting 'damaged', which is almost never.
>
>REINDEX indeed does fix "problems" where .CDX records other than the front-end record (or 2) get messed up by sudden power failures or inopportune network cable pulling and such. The TAG information areas at the front has very very little cause to be changed in most systems so is relatively immune from such messing.
>
Not so. I have seen numerous cases, even within the past couple of years, where data gets corrupted, either because of network crashes or power glitches. And the CDX doesn't seem to be any more immune than the DBF or FPT.