ADO or DAO - I am confused

[Malcy]

Hi
About three years ago when I started doing VBA I got a drift that ADO was the way to go so have very gradually worked up my ADO skills - still not that high but with help from you guys I get by.
I recall seeing somewhere that Microsoft are moving back to DAO being default in next version of Access - which if my recall is right, suggests that they have not found ADO up to the job.
Can anyone confirm this, and should I now start trying to think in DAO rather than ADO - and do my new programming in DAO?
Would very much appreciate any views.
Thanks

 

[Summerwind]

I know how you feel. I learned ADO after becoming comfortable with DAO because ADO was to be the preferred technology for the future.

Having now heard that DAO is to become the default again, I am not too happy, especially as I'm not sure if you can manipulate Word, Excel and Outlook through DAO.

I've decided to stick with ADO unless I'm forced to change.