Nancy,

This may or may not be the answer. If it is, Mark left out something in his list. In a discussion we had about INDEX on a few days ago, we discovered (to my surprise) that if you used INDEX ON Expr TAG Expr OF CdxFile, and named a non-structural CdxFile in which to create the index, you actually did not have to have the table open exclusive!

I think Michelle Cox made the discovery, which blew several experienced FoxPro people's minds. Well, at least it blew my mind.

Rich.

>Mark-
>
>I must be missing something important, because in my universe I have to have a table used exclusively to create an index tag. I tried it as you list, and yes, indeed, when I try INDEX ON ... TAG expr I get the error "File must be opened exclusively."
>
>So, how are you even getting to #4?
>
>>1) Open two VFP 5.0 sessions on the same machine.
>>2) SET EXCLUSIVE OFF, on both.
>>3) USE MyTable (any FREE table), in both sessions (same table used).
>>4) In one session, do an INDEX ON Expr TAG Expr - no problem.
>>5) In the other session, table is still modifiable. Try SET ORDER TO Expr - error: 'Table has no index order set'. Close this table with USE and try to re-open - error: 'File access denied'.