I think MS tried to move away from DAO with 2000, but realized the error of their ways.
From the Access team blog on 2007:
In Office Access 2007, new objects, properties, and methods will be added to DAO to support the new features in the Access database engine. For example, multi-valued fields created using the new Lookup Wizard will be accessible from code as DAO recordsets.
I don't think DAO is going anywhere in the near future. They wouldn't invest the time to add to it if they intended to drop it.
I have been wondering how they were going to move away from DAO. I have a database that will move Access objects (Reports and Queries) between databases. And the only way I could fiogure out how to move them is using DAO. So at a minimum they would have to add that functionality to another technology (ADO or other).
Thanks for the additional information. I still think, if you only learned one way to manipulate data in code, that ADO is a better choice. Although, once you understand how to use one technology it is easier to understand the other.