ADO or DAO??

Posted on 2003-02-21
Medium Priority
Last Modified: 2010-05-01
Could someone please tell me where I determine which one I am using? Which one should I be using? How do I tell it which one to use? I have looked at every menu in the software and I cannot find it to save my life. Also, does anyone know where there is a step by step explanation of how to use either?


Question by:madugas
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 53

Accepted Solution

Ryan Chong earned 136 total points
ID: 7997665
ADO is better and latest, try use ADO as can as possible.

Examples at:


Assisted Solution

NoviceScripter earned 132 total points
ID: 7998581
Hmmm......another case of ADO & DAO.
Ok some definition:
ADo-Active Data Objects
DAO -Data Access Objects
ADO is a new technology to VB and is not similar to DAO.Infact Microsoft refers to DAO as an 'intrinsic' Data Control. This means it implements data access using the MS Jet Database Engine -the same thing that powers MS access. Microsoft states that DAO is suited best for either single-system applications for small local deployments.
On the other hand ADO is much newer & more flexible and includes the capabilities of DAO as well as others. Microsoft suggests that because of this flexibility , it is recommended that new Database applications be created using ADO.
However with this added flexibility comes added complexity.
Once again, it is up to the user to decide, as VB 6.0 onwards supports both ADO & DAO.

Hope this helps.
LVL 44

Assisted Solution

Arthur_Wood earned 132 total points
ID: 7998910
in your VB project, under the ProjectMenu item...   select References, and you should then be able to tell which LIBRARY (Microsoft ActiveX Data Object X.X Library, or Microsoft Data Access Objects X.X Library) is checked.


Expert Comment

ID: 8901276
This old question needs to be finalized -- accept an answer, split points, or get a refund.  For information on your options, please click here-> http:/help/closing.jsp#1 
Experts: Post your closing recommendations!  Who deserves points here?
LVL 49

Expert Comment

ID: 8964117
Moderator, my recommended disposition is:

    Split points between: ryancys and NoviceScripter and Arthur_Wood

DanRollins -- EE database cleanup volunteer

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Article by: Martin
Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
This lesson covers basic error handling code in Microsoft Excel using VBA. This is the first lesson in a 3-part series that uses code to loop through an Excel spreadsheet in VBA and then fix errors, taking advantage of error handling code. This l…
Suggested Courses
Course of the Month15 days, 14 hours left to enroll

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question