DAO

[Abdul Shakeel]

Hi All,

Can anybody tell why & when we use DAO in our databases???

 

[Allen Browne]

DAO exposes the data model in Access. You want to use to to programmatically
read or modify the data, database schema, query definitions, security
information, or objects (forms, reports, ...) in the database.

Here is an introduction to DAO:
http://allenbrowne.com/ser-04.html

And here are are couple of dozen examples of using DAO code:
http://allenbrowne.com/func-DAO.html

 

[a a r o n . k e m p f]

DAo is fucking obsolete.

DAO isn't portable.
DAO forces you to clean up your variables (killing one of the main
efficiencies of VB / VBA)
DAO is just the old way of doing things.

ADO is more popular.
ADO is more flexible.
ADO is faster.
ADO is used by other applications-- like Dreamweaver for example.

DAO limits you to an obsolete database engine.

JET is stupid.

Even a raghead should have enough cojones to figure out that you
should use a real mans database.
fucking baby killer

-Aaron