>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
Jimi,
Since you are creating the index in the Load and deleting in the UnLoad, no other program/form/process is going to use the index at all unless you pass the name of it to them. Because you have it open, any changes you make to the table will be reflected in the index. And if the internal cache is updated via the SET REFRESH setting, the index will be updated as well.
HTH.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao