My opinion is ADO is the better was to go regardless of if you can get away with DAO.
ADO allows connections to most common databases without the need for DSNs. When the day comes that your boss says that the company is migrating everything to Oracle, SQL Server, My SQL, etc, you will have no...