>>The reason that it's so slow is that the application is not using "true" OLE DB access to the VFP data, it's using the ODBC provider for OLE DB and ODBC is slow.<<

Yeah, but ODBC is not that slow. I've used ODBC against VFP data with millions of records (with indexes) and I found it to be hardly noticeable (compared to native VFP).

Something else is a problem here.

Guy