ADO & DAO Introduction

Question

HI,

I am looking for some material giving introduction to DAO and ADO usage in VBA. Most of the material i came across give examples of how to use them. I am looking for a broader theory based definition of what they are and how they came about and the requirements for their usage.

thanks regards tksy

Answer 1

See Data Access Using Data Access Objects (DAO) and Microsoft ActiveX Data Objects (ADO)

Answer 2

Wikipedia is always good for a high level view and a little bit of history: DAO and ADO

Answer 3

If you are considering both ADO and DAO then it's likely you are interested in MS Access or Jet as a data source, in which case the following KB article is useful:

Choosing ADO or DAO for Working with Access Databases