I don't have an example of DAO. I use it heavily, but what I do can't really serve as an example. (I could post my document class, but it would only confuse you.)

If ADO works like DAO, you would first call AddNew, then set the values and then call Update...

A look at the reference supports my view, but I hate both the DAO and the ADO reference because they're both made for VB. This is another reason why I like the MFC DAO support: the reference is for C++...