Re: Any REAL reason to use ADO vs. DAO?

Tech-Archive recommends: Fix windows errors by optimizing your registry

On Tue, 1 May 2007 10:06:08 -0400, "Jim Carlock" <anonymous@localhost> wrote:

¤ : I echo what Ralph said. Since you're working with different data sources
¤ : ADO offers the most reliable options.
¤
¤ I disagree. Define reliable. It's a nonsense word. Everything is unreliable
¤ including ADO!

http://dictionary.reference.com/browse/reliable

DAO does not support OLEDB. Your options are limited to ODBC (and a few ISAM drivers). Personally
I've always found limitations and problems when using ODBC in conjunction with DAO.

¤ : DAO is limited to ODBC and ODBCDirect and the object model is
¤ : rather clunky.
¤
¤ I disagree, again Paul. Define clunky. That is a clunky attack on an amazingly
¤ efficient technology! <g>

http://dictionary.reference.com/browse/clunky

Ever try to marshal a DAO Recordset across processes? ;-)

¤ : The ADO object model more efficient and supports both ODBC drivers
¤ : and OLEDB providers (which are typically more stable).
¤
¤ Huhh? Is that a sentence? <g>

Sorry, that should be "is more efficient". Didn't mean to confuse you by the omission of that word.
;-)

¤
¤ : If you're working from within Access use DAO, otherwise use ADO.
¤
¤ I disagree again. DAO does great things for reading from Excel, CSV
¤ and some other FLAT file formats.

So what. I can do it in ADO as well - without the clunky object model. ;-)

¤ In fact, if someone wants to carry this further and expand their skills
¤ and knowledge, I'll go for that. I need to sharpen my own database
¤ skills and such.
¤
¤ Does not Windows XP use DAO?

Which feature are you referring to?

¤ And get this...
¤ Outlook Express uses a variation of DAO to manage .dbx files.

DAO or Jet? Don't confuse the two.

¤ Does Windows Mail use a variation of DAO or did Microsoft do
¤ the right thing and build their new mail databases in an open source
¤ format like SQLite?

Once again, DAO or Jet?

BTW, Access 2007 uses an enhanced version of Jet (ACE) but that doesn't mean it's recommended for
use outside of Access.

You trying to start something Jim? ;-)


Paul
~~~~
Microsoft MVP (Visual Basic)
.

Relevant Pages

  • Re: Back to DAO
    ... Also before I dig into the ADO, I want to understand the DAO concept so the ... ¤ transition will much easier for me. ... I wouldn't spend too much time with DAO as you may become attached to some features not present in ... ADO was designed to be a bit more universal with respect to data access and Microsoft Access ...
    (microsoft.public.vb.database.dao)
  • Re: DAO vs ADO
    ... lets look at the original question ... method is better ADO or DAO?" ... ¤ Hi, ...
    (microsoft.public.vb.database)
  • Re: Back to DAO
    ... > ¤ transition will much easier for me. ... > I wouldn't spend too much time with DAO as you may become attached to some ... > ADO. ... > access and Microsoft Access ...
    (microsoft.public.vb.database.dao)
  • Re: DAO vs ADO
    ... ¤ Hi, ... assure you that ADO is the best way to go. ... I originally started writing in DAO, but regretted it, DAO is slower then ... ADO provides an additional API layer to the data access process so I'm afraid you're ...
    (microsoft.public.vb.database)
  • Re: DAO vs ADO
    ... Which access ¤ method is better ADO or DAO? ... Unless you plan on updating your Access 2003 database to SQL Server or another database platform I would probably stick with DAO. ... ADO is fine but it's not as closely tied to the Jet database engine so you may find some features lacking. ...
    (microsoft.public.vb.database)