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?
Ernie Veniegas
Micro System Solutions
... sensible software by design