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?