Steven,

Please forgive me if I've overlooked something...

you index a table ONCE (assuming a 'production' index) and thereafter it is kept up-to-date every time you add a record.
So, yes, you do need to have exclusive access to the table to do the INITIAL index creation, and after that everything is automatic.

Since you are using a view, then you shouldn't have to do ANY changes to the programming itself to reap the benefits of the index(es) PROVIDED THAT you create TAGs that are relevant to the SELECTs that you are doing.

good luck


>Craig,
>
>Since I sent you the last message I took down the app. The slowness of the sql query is only present when the useage is heavy. Because my app design skills were and still are lacking, when I designed this app, I added all the tables the app needed in the main form data environment. I am working on an update that is designed to use the tables as needed and then do a Use In 0 so every table is not in constant use by everyone. I hope this makes a difference. But until I get this deployed is it impossible to index a table without exclusive rights?