ADO (ActiveX Data Object) and DAO (Data Access Objects)

[Access_Novice]

What exactly is ADO an DAO? How do they tie into MS Access? How and when are they used?

[ItsMe]

You can probably write an entire book on each. ADO is typicaly used with connections to objects outside the desktop database and DAO is useful with objects inside the database.

An example of their use would be to open a recordset to view, edit, or delete records.

[MarvinM]

I want to revive this discussion.

I understand that there is a whole lot of information about ADO and DAO. We don't need an exhaustive elaboration of each.

Could someone please give us the boiled-down, "cheat sheet" version of what the basic differences are between these object libraries and how/when we should choose between them?

Thank you!
Marvin M