HI Barbara:

Can you tell me more specifically what you ended up having to do to make this work?

As you may have read previously, I used to just do this:

USE MyTable EXCLU
INDEX ON student_cd TAG student_cd ADDITIVE
REINDEX
USE IN MyTable


So I modified my code so that I explicity OPEN MyDataBase EXCLUSIVE before USEing MyTable. It now reads like this:

OPEN MyDatabase EXCLU
USE MyTable EXCLU
INDEX ON student_cd TAG student_cd ADDITIVE
REINDEX
USE IN MyTable
CLOSE DATA ALL

If I check MyTable via FoxPro, no sweat, the new student_cd index is there. so far so good. But if I OPEN MyDatabase and issue VALIDATE DATABASE in the command window, it still says ...

"Need EXCLUSIVE writeable access to rebuild structural index.'
"Object #XX ('MyTable'): One or mmore structural indexes missing from DBC."

Now, if I issue VALIDATE DATA RECOVER, it lets me (manually) add the missing index and the problem goes away. (But Fox help says you can't issue VALIDATE DATABASE RECOVER within a program).

Help?! What am I missing?