Difference between ADO and DAO

[dirkg]

Coud anyone tell me what the differnce is between ADO and DAO? And which of the two would you recommend to use?

Thanks in advance.


Greetz,

Dirk

 

[jimmythegeek]

This is a good starting link:

http://www.thebestweb.com/db/dbaccesscode.asp

If you are using Access 97 or earlier, use DAO, 2000 or later, use ADO. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?

 

[cmmrfrds]

Here is another good link. It does a code comparison with examples of DAO and ADO. The intent is how you need to recode the DAO functions in ADO.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dndao/html/daotoadoupdate.asp

If you are only using Access then DAO is fine, but if you use or intent to use other products then the ADO you learn in Access with be transferable to the other products. Products such as ASP, Java, VB, or other 3rd party front end and web based tools.

 

[jimmythegeek]

Don't forget, in 2000 and higher, to dimension objects specifically:

Incorrect:

Dim rs As Recordet
Dim fld As Field

Correct:

Dim rs As DAO.Recordset OR ADO.Recordset
Dim rs As DAO.Field OR ADO.Field

etc. Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?