DAO vs ADO

[shamas21]

Hi all

Can someone tell me the benefit of ADO? Im using DAO to connect to the object in my database and other databases on my C drive, but why use ADO rather than DAO?

Also what is ADOBD?

Thanks

 

[Uncle Gizmo]

DAO is quite powerful and has been reintroduced into MS Access 2007

I believe one advantage ADO has over DAO is that you can create portable Recordsets.

 

[Pat Hartman]

DAO was designed to work with Jet so it is more efficient when working with Jet than ADO is and has features that were never included in ADO. ADO is supposed to be more efficient for working with ODBC databases. I have to admit that I use DAO 90% of the time out of shear laziness and only use ADO when I have to. Most of my applications are SQL Server and I rarely have issues.