I think Sergey is right in this case. I do remember reading that VFP 9 allows creation of index tags without exclusive access. I wanted to add this but switched to other task and forgot.

Yes, I meant structural indexes (CDX).

>>>I'm working on an old app that runs without errors in production (VFP 9 runtime) but is giving me an error when I run it in VFP9 SP2.
>>>
>>>I am creating a temporary file, and then creating an index for it.
>>>
>>>Example:
>>>
>>>Select ... into DBF filename
>>>USE filename
>>>Index on fieldname tag indexname
>>>
>>>I get the "File must be opened exclusively" error.
>>>
>>>So far, the only difference I can find is SP1/SP2. Is this a SP2 issue?
>>>
>>>Thanks,
>>>Larry Morelli
>>
>>The file always had to be opened exclusive to add indexes, AFAIK.
>
>Not always,
>it depends what index you create.
>If you use this:
>INDEX ON ... TO xxxx. That will create an IDX file and that command didn't require exclusive use of the table.