>Is there anyway to set an index on a fox table through ado before you run a sql command through ado. I have several large queries that I am trying to run through VB/ADO and was wonding if this was a way to get my response time down.
>

The current index doesn't have a bearing on query performance via ODBC.