Data Objects History

Crilen007

Uhm, Title... *shrug*
Local time
Today, 03:28
Joined
Jun 13, 2003
Messages
531
DAO is the newest type of reference correct?

What was the history of these?

IE:

CDO First
ADO second
DAO third?

Also, is there a code library file for DAO (if DAO is the newest).

Thanks for answering =)
 
Last edited:
Im not quite sure what you mean, and ive never heard of CDO but to the best of my knowledge:

ADO stands for Active Data Objects
DAO stands for Data Access Object(s) (cannot remember if the s is on there)

ADO actually is used for just about anything.. things like ActiveX and COM should be part of ADO (sorta).

I think you're confusing ADO with ADODB which is Active Data Objects DataBase.

DAO *should* come by default with windows/access. Which version is dependant on your OS/OFFICE version.

Just find it in the reference list, it's typically called "Microsoft DAO 3.6 Object Library"
 
DAO came with Access 95 and 97.
ADO was heralded as the future and is the default in A2000 and A2000.
Everyone loved DAO too much; it's the default in A2003.

To set a reference to DAO, go to Tools -> References and select Microsoft DAO Library vx.x.

If you don't intend on using ADO you can uncheck the reference to it.
If you don't intend on unchecking it, you will have to be careful in which objects you declare as DAO and which ADO.

I've also never heard of CDO.
 
Last edited:
I suggest you use DAO, it seems to handle table locking better than ADODB

On a side note: anyone know if DAO works in ASP?
 
There a code library file for DAO?

Like code references for the Code Librarian software?
 
If you mean your looking for an API then you can either

1) Search google for the official API
2) Use VBA's built in Object Browser
3) Read tutorials and learn it that way.
 
Mile-O-Phile said:
I've also never heard of CDO.

CDO is used for messaging applications. You may have heard of CDONTS?
This enables you to send automated emails via .asp files.
They are an extension of the MAPI collection.

ReAn said:
On a side note: anyone know if DAO works in ASP?

No it doesn't - you have to use ADO to access data sources via asp files along with your appropriate db driver.
 
Hmm,, original API i cant find on google, brings up a ton of unrelated things...

Im just looking for DAO code samples so i can learn the basics.

Thanks for all the replies so far!
 
Search the Microsoft knowledge base and MSDN library. There are lots of articles. You'll also find code samples by searching here.
 

Users who are viewing this thread

Back
Top Bottom