Ofcource... DAO in local MSAccess database is the best (and fastest) way to working with recordsets.
But there is one little moment - IMHO:
using ADO for msaccess - masochism 'cause all querries in msacces using JetMachine and DAO using jet machine. And I think it's NOT coincidence.
But when you want to connect to MSSQLServer...all my fellows recommends to use ADO for better data safe.

PS: there is some fastes ways in MSAccess
=========
dim db as database
set db = currentdb
db.execute "select * from table"
db.close
=========

is faster in "update, insert, delete and select" than

=========
docmd.runsql "select * from table"
=========

and a kind of mystery: dbOpenDynaset is faser than dbOpenSnapShot