[AccessD] DAO vs ADO

Drew Wutka DWUTKA at Marlow.com
Tue May 15 11:22:56 CDT 2007


That is a pretty loaded question, and you've already gotten several
answers.

I'd like to point out on particular quirk in a little more detail.  I
use ADO for practically everything.  ADO is more flexible then DAO,
since DAO is designed specifically for JET, where ADO is more generic.
However, when working with Access, ADO has some limitations.  One such
limitation, which has been mentioned is that DAO understands Access
objects (I believe Charlotte pointed this out.), but that affects more
then just trying to manipulate those objects, in fact, it's something
that I ran into last night.

I had a query I wanted to access through code.  The query had a criteria
based on a combo box on a form.  ADO would not run the query, because it
doesn't know what Forms!frmSomething!cmbSomething is.  DAO would run it,
but ADO failed.  I still stuck with ADO, and built the SQL as a string
using the value in the combo box, but if I had used DAO, I could have
used a prebuilt query.

Drew

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Jim Hewson
Sent: Tuesday, May 15, 2007 9:18 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] DAO vs ADO

I'm confused when looking at these two libraries.  My questions are
many, so I listed only a few below.
1.  What is the difference?  Yeah I know, this is a loaded question, but
how do I know when looking at code it's either one?
Can they be mixed?

2.  Which is recommended for MDBs - or is there no difference in
performance?

3.  I read somewhere, that ADO is required for ODBC to SQL Server with
an Access FE - is that correct?

That's enough for now, Thanks!

Jim
 
Jim H. Hewson
Applications Support Manager
Karta Technologies, Inc.
5555 Northwest Parkway
San Antonio, Texas 78249
210-582-3233 
jhewson at karta.com
 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com
The information contained in this transmission is intended only for the person or entity to which it is addressed and may contain II-VI Proprietary and/or II-VI BusinessSensitve material. If you are not the intended recipient, please contact the sender immediately and destroy the material in its entirety, whether electronic or hard copy. You are notified that any review, retransmission, copying, disclosure, dissemination, or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited.





More information about the AccessD mailing list