Hi Steve.

>Has anyone done any time tests to see if ADO is faster or slower than ODBC?

I've done a little bit of testing (nothing rigorous) and found that ADO is a little bit faster than ODBC if you don't care about the resulting format (eg. if you can use either a cursor or an ADO RecordSet). However, if you need a VFP cursor (eg. to bind to a grid or in a report), then the additional task of converting the ADO RecordSet to a VFP cursor makes ODBC faster.

However, ADO is also more scalable, so performance isn't necessarily the only criteria.

Doug