ADO or DAO?

[David Portwood]

I have two Access 2000 texts. One uses ADO (and says DAO is outmoded
technology - is this true?) and the other uses DAO. I must say, the DAO
commands seem less complicated, at least when it comes to opening a
recordset.

 

[Allen Browne]

If your data is stored in Access tables, use DAO.

DAO is the native Access library.
The A in DAO *is* Access.
Access itself uses it (e.g. to run its queries.)

When Access 2000 was released, MS did try to get us to switch to the more
generic ADO. That's where the "outmoded" comments originated. Since that
time, ADO has become outmoded as a generic library, replaced by the quite
different ADO.NET.

In Access 2003, the DAO library reference came back as a default, and
continues to be so in Access 2007.

There may be reasons to use ADO if you are connecting to data data is other
sources, but if you use Access tables, DAO lives!

Here's some links that might help:

Libraries to use for different versions of Access:
http://allenbrowne.com/ser-38.html

Picture of the DAO object model:
http://allenbrowne.com/ser-04.html

25 DAO code examples:
http://allenbrowne.com/func-DAO.html

Comparison of the field names in the different libraries:
http://allenbrowne.com/ser-49.html

 

[Todos Menos [MSFT]]

don't use MDB for anything
and don't use DAO for anything


use SQL Server you ****ing dipshit

DAO hasn't been included with Windows, Office or MDAC for 10 years

SERIOUSLY

do the math

anyone using MDB or DAO should be fired and then spit upon

 

[Todos Menos [MSFT]]

just because

DAO -> ADO -> ADO.net that doesn't mean that DAO is cool again

Office Web Components-- in Office 2003-- those don't support DAO.
RIGHT?

ADP in Office 2003-- that doesn't support DAO

so just because 1/3rd of Office _ALLOWS_ DAO that means that it's
suddenly the cool thing to do again?

STFU you ****ing newbie retards

only a ****ing retard in a wheelchair-- like michael kaplan-- who
doesn't have the mental capacity to learn SQL Server because he is
_RETARDED_

only Michael Kaplan should use DAO.. just because he doesn't have the
capacity to learn a new library

****ing retards


lose the training wheels, dipshits

 

[David W. Fenton]

If your data is stored in Access tables, use DAO.

DAO is the native Access library.
The A in DAO *is* Access.

Er, that would be *lower-case" access, not Access the Microsoft
product -- it's just the generic meaning of access, as in gaining
access to data.

Access itself uses it (e.g. to run its queries.)

I'm not certain about that. At one point this came up in a
discussion with Michael Kaplan, and I think he said that Access
talks directly to Jet, rather than using DAO. If this were not so,
then there'd be no need for a DAO reference. It is true that some
objects that we think of as specifically belonging to DAO are
available without the DAO reference. For instance, CurrentDB and
DBEngine are all properties.methods of the Access Application
object, and available without any reference to DAO.

So, I wouldn't make the claim so strongly as you make it. Access
doesn't need an intervening layer to talk with Jet for certain
operations (remember after all that an MDB file, even a front end,
is a Jet database, and that much of Access itself is written in
Access itself, e.g., wizards and so forth).

When Access 2000 was released, MS did try to get us to switch to
the more generic ADO. That's where the "outmoded" comments
originated. Since that time, ADO has become outmoded as a generic
library, replaced by the quite different ADO.NET.

However, classic ADO is still quite useful for working with non-Jet
data, more specifically, SQL Server.

It's too bad MS completeley mucked up the ADO introduction in
Access. ODBC really is pretty outmoded as a database abstraction
layer, since it isn't up-to-date on a number of features that are
now widely supported in mainstream database engines.

In Access 2003, the DAO library reference came back as a default,
and continues to be so in Access 2007.

Does the default DAO in an ACE read legacy Jet data without
problems? That is, DAO is now somewhat more complicated, as there
are two distinct Jet database engines to support, the traditional
Jet 4.0 lineage, and the new fork for the ACE.

There may be reasons to use ADO if you are connecting to data data
is other sources, but if you use Access tables, DAO lives!

And is now under new development because the Jet database engine (in
its ACE incarnation) is once again in live development.