As far as updating data, I am equally comfortable using either ADO or DAO.  If ADO is more efficient, that is what should be used.  But when manipulating objects inside Access, DAO is a perfect fit when using the traditional MDB applications.

I am so impressed with the Access Data Projects, that any future Access/SQL work I do will be with this technology.