Hi All,
I've been doing some timing between SQLOLEDB and Native Access. These timings using the same code and connection properties, except that the Provider is changed.
A select statement is sent to a remote SQL Server over the internet using HExecuteSQL. Approximately 7300 records are returned in the data source. The data source is then looped through each record.
The time to return the records and loop through them is:
SQLOLEDB 18.4 secs
Native Access 4.5
Perhaps there are some tweekings that can be made to the connection to enhance each.
From where I'm sitting, Native Access fast.