5 minutes ago I've made a test
Table OrderNumber contains 50.000 records and linked from MSSQLServer 2000 though the ODBC, client is MSAccess'2000. As you see, there were tested DAO And ADODB.
DAO - 25 sec.
ADODB - 35 sec.
Dim DB As Database
Set DB = CurrentDb
Dim RSol As DAO.Recordset
'Dim RSol As ADOdb.Recordset
'Set RSol = New ADOdb.Recordset
SqlStr = " select * " & _
" from OrderLine " & _
" order by OrderNumber ASC, OrderType ASC, LineNumber ASC"
Set RSol = DB.OpenRecordset(SqlStr, dbOpenDynaset, dbSeeChanges, dbPessimistic)
'RSol.ActiveConnection = GetConnectionStringNow
'RSol.Source = SqlStr
'RSol.CursorType = adOpenDynamic
'RSol.LockType = adLockPessimistic
'RSol.Open
'RSol.MoveFirst
While Not RSol.EOF
RSol.MoveNext
Wend
RSol.Close
Set RSol = Nothing
DB.Close
if recordset creation will be:
Set RSol = DB.OpenRecordset(SqlStr, dbOpenDynaset)
then time in DAO will be 9 sec. =)