Hi Ian,

ADO returns a recordset, not a table so there is no index the way we traditionlly think of indexes. In the SELECT of the data, define an ORDER BY to set the sort order of the returned records, or a WHERE clause to return records with specific values for selected fields. As long as your expressions are optimizeable by Rushmore, ADO will use the indexes on the backend to retrieve the data.

HTH.

Mike

>When I connect to a FoxPro database using ADO via ODBC, how do I secify which index to use?
>
>Thank you very much,
>
>Ian