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.