DAO, Recordset, RecordsetClone, ADODB

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Abdul Shakeel - 29 May 2008 05:07 GMT

Hi All,

Could anyone tell me what are the Definations of DAO, Recordset,
Recordsetclone, & ADODB. when, why & which conditions we used them in our
database

Reply to this Message

Stefan Hoffmann - 29 May 2008 09:35 GMT

hi Abdul,

> Could anyone tell me what are the Definations of DAO, Recordset,
> Recordsetclone, & ADODB. when, why & which conditions we used them in our
> database

You have to distinguish between DAO and ADO first:

DAO = Data Access Objects
ADO = ActiveX Data Objects

DAO is the older technology, ADO the newer. As both are dealing with
data they have both a Recordset object which holds the data.

ADODB is the name used when programming with ADO, its is namespace.

In a fresh .mdb you can't use ADO without setting a reference to the ADO
library.

The RecordsetClone method belongs to the Access.Form object. It returns
a Recordset object holding a copy of the data used/displayed by the form.

mfG
--> stefan <--

Reply to this Message

Douglas J. Steele - 29 May 2008 12:24 GMT

> hi Abdul,
>
[quoted text clipped - 7 lines]
>
> DAO is the older technology, ADO the newer.

<picky>Perhaps a moot distinction, since DAO is now ACE, and ADO is now
dead.</picky>

> As both are dealing with data they have both a Recordset object which
> holds the data.
[quoted text clipped - 3 lines]
> In a fresh .mdb you can't use ADO without setting a reference to the ADO
> library.

All versions of Access since 2000 have had a reference to ADO by default.
Access 2000 and 2002 didn't have a reference set to DAO, but it's there by
default in Access 2003 and 2007. Unfortunately, it's lower in the sort order
than the reference to ADO, so ADO get precedence if you don't diambiguate.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

Reply to this Message