Re: a97 to a03 and DAO to ADO

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Hi Allen,

As a VB Developer, I know the performance benefits of utilizing ADO over DAO.

The Access DB I am asked to upgrade utilizes a combination of Access tables
and SQL Server tables through ODBC. I was under the assumption that the
performance gains realized in ADO in VB would translate into similar gains in
Access.

Would this not be the case?



"Allen Browne" wrote:

> Why do you need to change the code to ADO?
>
> DAO is the native Access library - the one that Access itself uses.
> If you are using JET tables (the tables in Access), then DAO is still the
> most appropriate library to use.
>
> --
> Allen Browne - Microsoft MVP. Perth, Western Australia.
> Tips for Access users - http://allenbrowne.com/tips.html
> Reply to group, rather than allenbrowne at mvps dot org.
>
> "Mario G." <MarioG@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:4BFC6F94-5963-4F43-833B-1007A8C695AD@xxxxxxxxxxxxxxxx
> >I am preparing to convert an Access 97 mdb to Access 2003. I've similated
> > the upgrade using Access 2000 with no problems. However, I also need to
> > upgrade the code from utilizing DAO 3.6 to ADO.
> >
> > Does anyone have any good references for this (books, web sites, etc....)
> > Has anyone done this? What problems did you encounter and had to resolve.
> >
> > Thanks.
>
>
>
.

Relevant Pages

  • Re: a97 to a03 and DAO to ADO
    ... You can use both ADO and DAO in the same MDB, Mario, as long as you're ... > The Access DB I am asked to upgrade utilizes a combination of Access ... >>> upgrade the code from utilizing DAO 3.6 to ADO. ...
    (microsoft.public.access.conversion)
  • Re: a97 to a03 and DAO to ADO
    ... rich and rapid development environment, ... forms from Access/DAO to semi-bound forms using ADO: ... because DAO is the native Access method, ... > The Access DB I am asked to upgrade utilizes a combination of Access ...
    (microsoft.public.access.conversion)
  • Re: a97 to a03 and DAO to ADO
    ... The client is peforming an OS and Office upgrade. ... Considering some of the feed back, it may worth another look at keeping DAO ... >> I've developed were all done utilizing ADO. ... >>> project into an ADP, I would only recomend this for 2 reasons, how much ...
    (microsoft.public.access.conversion)
  • Re: a97 to a03 and DAO to ADO
    ... Why do you need to change the code to ADO? ... DAO is the native Access library - the one that Access itself uses. ... rather than allenbrowne at mvps dot org. ... > the upgrade using Access 2000 with no problems. ...
    (microsoft.public.access.conversion)
  • Re: How to enforce subtypes/supertypes in Access 2000?
    ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
    (microsoft.public.access.tablesdbdesign)