Denise,
Is it a free table? What flavor of FoxPro? The status of the CDX is stored in one of the first byte of the dbf. I can't put my hands on code right now that shows what each bit in there indicates. It's quite possible one of the other programs is altering that byte and thus confusing FoxPro. Look at that byte either with a hex file viewer or fread it with some FoxPro code for a good file and the damaged file to see the difference.
>I've got this table over at a client's office that's giving me fits. Every couple of days it seems it loses it's index. This table only has one index. The wierd thing is that the .cdx file is still there, but when you modi struct the table, there's no index to be seen.
>
>I highly doubt it's something caused by our code becuase that hasn't changed in several months and this is a relatively new problem. I'm going to confirm that tomorrow, but I really don't believe it's due to the code.
>
>This one table is accessed by other programs, from what I understand, so I'm thinking it's some other program that's causing the problems, but I don't even know where to begin to look. Especially with the wierdness of the .cdx still there but no index.
>
>If anyone could give me a clue as to where to begin looking, I'd greatly appreciate it.