>hi all,
>
>I'm gonna create a form which allow users to edit the content of MyTable.
>MyTable has an index file MyIndex
>
>But in my case the setting of MyIndex does not suit my requirement, at the same time I can never change the structure of the table or the index.
>
>So, at the load event of my form, I create a temp index file (TempIndex) for MyTable, do the job, and then delete it at the MyForm.unload event.
>
>My question is, since users can change the content of MyTable, do I need to update the original index file (MyIndex) as well, in order to make sure any other programs wouldn't have problems when they use the files? And how? Any idea or suggestions are greatly welcomed!
>
>Jimi

One important consideration: For working correctly on a network, the index name should be created with sys(2015). Thus, you have no conflicts when two different users create temporary indices.

You could also create indices on the user's temp folder (sys(2023)), but there is no guarantee that this will always be on the user's hard disk (if the variables aren't set correctly on the user's machine, the temporary files will still be created on your default folder - which might be the shared network folder).

Hilmar.

Hilmar.