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

hi Abdul,

Abdul Shakeel wrote:
> 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 <--

"Stefan Hoffmann" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> hi Abdul,
>
> Abdul Shakeel wrote:
>> 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.

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

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