Wrox Programmer Forums

Need to download code?

View our list of code downloads.

| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3
This is the forum to discuss the Wrox book Access 2007 VBA Programmer's Reference by Teresa Hennig, Rob Cooper, Geoffrey L. Griffith, Armen Stein; ISBN: 9780470047033
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Access 2007 VBA Programmer's Reference ISBN: 978-0-470-04703-3 section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 14th, 2010, 03:21 AM
Friend of Wrox
Points: 689, Level: 9
Points: 689, Level: 9 Points: 689, Level: 9 Points: 689, Level: 9
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Sep 2010
Posts: 171
Thanks: 0
Thanked 14 Times in 14 Posts
Default ADO vs. DAO

Hi all,
Just got the 2010 version of this book, and on pg. 356 it says the latest version of DAO is 14.0, which ships with Office 2010. Yet when I look in references in the VBE, the only reference i have is to DAO 3.6. Is this errata or is something amiss with my installation, etc?

Also, some sites say DAO is either obsolete or going to be deprecated. Yet this book says it has grown in popularity (my last version of Access was 2000, so I'm like 10 years behind the times). Since I'm new to DAO and ADO, any advice on which i should learn first?

Any help will be appreciated.
Reply With Quote
  #2 (permalink)  
Old January 20th, 2011, 09:50 PM
gjgriffith's Avatar
Wrox Author
Points: 517, Level: 8
Points: 517, Level: 8 Points: 517, Level: 8 Points: 517, Level: 8
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jul 2009
Location: Boulder, CO
Posts: 110
Thanks: 5
Thanked 14 Times in 14 Posts
Default ADO vs. DAO

Hello mtranchi,

I saw your posts here and wanted to say thanks for sending your questions and comments over to us. It looks like you have several questions here, so I want to reply to each individually:
  1. You said: "Just got the 2010 version of this book, and on pg. 356 it says the latest version of DAO is 14.0, which ships with Office 2010. Yet when I look in references in the VBE, the only reference i have is to DAO 3.6. Is this errata or is something amiss with my installation, etc?"

    Actually, sorry to ask you to do this, but since this question is about the Access 2010 book, can you post this question in this forum:
    http://p2p.wrox.com/book-access-2010...reference-597/
    <br />
  2. You said: "Also, some sites say DAO is either obsolete or going to be deprecated."

    Well, there are always a lot of rumors out there and please don't believe everything you read about Access, unless is it an official announcement from Microsoft. DAO has not been deprecated in Access 2007 or Access 2010, and in fact, has been updated in both cases. As of now, you should still be safe to use DAO.
    <br />
  3. You said: "Yet this book says it has grown in popularity (my last version of Access was 2000, so I'm like 10 years behind the times)."

    DAO was part of the Access 2000 release (although the default reference was set to ADO, which was a change from 97). DAO is still included with Access, has had updates since 2000, is very popular these days to access data.
    <br />
  4. You said: "Since I'm new to DAO and ADO, any advice on which i should learn first?"

    Hmm, that is a tough question and there is much debate over this particular topic. It has been my experience, when developers advocate one library over the other, it is typically for some small feature that is not supported by the other library that is specific to their task. But overall, you can accomplish most data related tasks with either library. I think a lot of developers who start in Access (i.e. haven't programmed in other languages before), start with DAO and then move on to ADO. However, some developers start in other languages, such as .NET or ASP, and may already have some knowledge and experience with ADO, so they are more familiar with it and choose ADO over DAO. Overall, you can accomplish most data related tasks with both, although each has it's own unique features not found in the other. Also, DAO is native to Access and there are lots of different development environments that support some form of ADO. So really, the choice is up to you, but in my very humble opinion, it is probably easiest to start in DAO and move to ADO if you haven't had any experience with either previously, just because it is the default in Access 2007.
<br />
Anyway, I hope this has helped and answered all of your questions, but if you need anything else here, please feel free to reply to this thread and I will do what I can to help out! And thanks again for your posts, we really appreciate your patronage!

Sincerely,
Geoffrey L. Griffith
http://www.ImagineThought.com
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADO or DAO knowledge76 Access VBA 3 October 12th, 2015 04:26 PM
DAO vs. ADO SerranoG Access VBA 11 December 5th, 2006 01:19 PM
Dao to Ado vrtviral Access VBA 5 February 19th, 2005 11:13 AM
ADO vs DAO perrymans BOOK: Expert One-on-One Access Application Development 0 October 24th, 2004 11:36 PM
DAO / ADO? merguvan Access VBA 8 January 18th, 2004 07:39 AM



All times are GMT -4. The time now is 11:10 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.