DAO, Recordset, RecordsetClone, ADODB

[Abdul Shakeel]

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

 

[Stefan Hoffmann]

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 <--

 

[Douglas J. Steele]

hi Abdul,


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.

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

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.

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.