ADO Vs. DAO and Access 2002 
Author Message
 ADO Vs. DAO and Access 2002

I'm reading about ADO in the 2000 Access Developers Handbook. Just the
limited Find method (one-field criteria!) and the worthless "Errors
occurred" error description have already convinced me that ADO isn't worth
even considering over DAO. Is DAO still usable with A2002? Is ADO better now
(Find method and Error descriptions)? Would/have you made the switch and
why?
Many thanks!
David


Wed, 20 Apr 2005 04:20:46 GMT  
 ADO Vs. DAO and Access 2002
yes dao is

Quote:
> I'm reading about ADO in the 2000 Access Developers Handbook. Just the
> limited Find method (one-field criteria!) and the worthless "Errors
> occurred" error description have already convinced me that ADO isn't worth
> even considering over DAO. Is DAO still usable with A2002? Is ADO better
now
> (Find method and Error descriptions)? Would/have you made the switch and
> why?
> Many thanks!
> David



Wed, 20 Apr 2005 04:27:28 GMT  
 ADO Vs. DAO and Access 2002
If you're using Access on the front-end and Jet on the back end, DAO rocks,
and yes it works in Access 2002. Access 2002 doesn't add the DAO reference
automatically to new MDBs, but you can easily add it yourself - from within
the VBA editor, choose References from the Tools menu and check Microsoft
DAO 3.6 Object Library. Uncheck the Microsoft ActiveX <version number> Data
Objects Library if you're not using it.

ADO is still worth learning if you think you may work with ADPs and MSDE or
SQL Server, though.

--
Brendan Reynolds (MVP)


Quote:
> I'm reading about ADO in the 2000 Access Developers Handbook. Just the
> limited Find method (one-field criteria!) and the worthless "Errors
> occurred" error description have already convinced me that ADO isn't worth
> even considering over DAO. Is DAO still usable with A2002? Is ADO better
now
> (Find method and Error descriptions)? Would/have you made the switch and
> why?
> Many thanks!
> David



Wed, 20 Apr 2005 04:57:42 GMT  
 ADO Vs. DAO and Access 2002
Thank you for the info! I'll continue using DAO and reading about ADO.
David

Quote:
> If you're using Access on the front-end and Jet on the back end, DAO
rocks,
> and yes it works in Access 2002. Access 2002 doesn't add the DAO reference
> automatically to new MDBs, but you can easily add it yourself - from
within
> the VBA editor, choose References from the Tools menu and check Microsoft
> DAO 3.6 Object Library. Uncheck the Microsoft ActiveX <version number>
Data
> Objects Library if you're not using it.

> ADO is still worth learning if you think you may work with ADPs and MSDE
or
> SQL Server, though.

> --
> Brendan Reynolds (MVP)



> > I'm reading about ADO in the 2000 Access Developers Handbook. Just the
> > limited Find method (one-field criteria!) and the worthless "Errors
> > occurred" error description have already convinced me that ADO isn't
worth
> > even considering over DAO. Is DAO still usable with A2002? Is ADO better
> now
> > (Find method and Error descriptions)? Would/have you made the switch and
> > why?
> > Many thanks!
> > David



Fri, 22 Apr 2005 21:51:13 GMT  
 
 [ 4 post ] 

 Relevant Pages 

1. ADO Recordsets and Forms (ADO vs DAO)

2. Using ADO Recordset with Forms (ADO vs DAO)

3. ADO vs DAO vs ADODB

4. DAO Vs. ADO

5. DAO ADO Access vs Excel

6. Access ADO vs. DAO

7. ADO vs DAO for Access Queries via ASP

8. ADO vs DAO for Access Queries via ASP

9. DAO 3.5 vs 3.6 (Access 97 vs Access 2000)

10. ADO vs DAO


 
Powered by phpBB® Forum Software © phpBB Group