Ah-ha... interesting... how do you suppose VFP distiguishes between the two?

Mark

>>Hi Craig,
>>
>>The table is on a local drive.
>>
>>Mark
>>
>>>>Heelo, All!
>>>>Can someone please explain these results:
>>>>
>>>>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'.
>>>>
>>>>It's like the table went from SHARED TO EXCLUSIVE use in the first session, because of the INDEX command!
>>>>
>>>>All ideas will be appreciated!
>>>>TIA
>>>>Mark
>>>
>>>Is the table on your local drive or the network?
>
>That explains it. Because it is local, VFP assumes that no one else will need access to the table and will allow you to do this.