Jim's right...You create a CDX index (INDEX ON ... TAG ...) once. If you add lots of data, it may help to reindex periodically, but you'll still need EXCLUSIVE use of the tables.


>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?