I am attempting to connect to foxpro free tables using ADO with the VFPOLEDB
The problem is everytime I do a SELECT * FROM [Tablename] WHERE [Criteria].
The query takes over 2 minues to run. I don't think the connection is using
the Indexes specified on the table.
Does anyone know a way to force ADO connections to use a specific index on a
foxpro table? Or a way to speed up this process?
I've tried using "SELECT * FROM [USE INDEXSEEK([index name]) [Table name]
But this fails. With ADO you get an '[USE INDEXSEEK([index name]).dbf' does
not exists. I've also tried this same pass through technology with
DAO/ODBC connection and get "ODBC--call failed". Any information will be