Access XP - DAO or ADO

[Becky]

Hi - I'm just starting out with Access XP after using
Access 97 for years. What is better to use - DAO or ADO?
Also, when running a query (i.e. append, update, etc) in
VBA, what is better to use - a docmd.openquery statement
or an execute method? Thanks!

 

[Van T. Dinh]

If you use Access Tables, use DAO.

Execute is slightly more efficient AFAIK.