Access 2000 - Queries in code - ADO or DAO

Hello
I am going to start making some of my queries in code. (VB in Access 2000) .
Should I use ADO or DAO? Does it make a big difference and why?

Thanks
William Roberts

re: Access 2000 - Queries in code - ADO or DAO

If you are using Access' default Jet databases, there are many advantages to
continuing to use DAO:

-- DAO is the native language of Jet
-- DAO is faster with Jet than ADO
-- DAO is more complete for Jet than the
combination of ADO and ADOX

IMNSHO, there are few advantages to using ADO, but some are:

-- Accessing data in XML tables
-- Accessing other data in databases that
have an ADODB driver but no ODBC
driver available

others may be able to suggest additional reasons for using ADO. I would have
to have some _compelling_ need in order to use anything but DAO with a Jet
database.

Larry Linson
Microsoft Access MVP

"William Roberts" <williamr107@hotmail.com> wrote in message
news:0zclb.23375$Ee6.17201@nwrddc01.gnilink.net...[color=blue]
> Hello
> I am going to start making some of my queries in code. (VB in Access 2000)[/color]
..[color=blue]
> Should I use ADO or DAO? Does it make a big difference and why?
>
> Thanks
> William Roberts
>
>[/color]

re: Access 2000 - Queries in code - ADO or DAO

Thanks Larry

"Larry Linson" <bouncer@localhost.not> wrote in message
news:Q_clb.13612$Y1.10623@nwrddc03.gnilink.net...[color=blue]
> If you are using Access' default Jet databases, there are many advantages[/color]
to[color=blue]
> continuing to use DAO:
>
> -- DAO is the native language of Jet
> -- DAO is faster with Jet than ADO
> -- DAO is more complete for Jet than the
> combination of ADO and ADOX
>
> IMNSHO, there are few advantages to using ADO, but some are:
>
> -- Accessing data in XML tables
> -- Accessing other data in databases that
> have an ADODB driver but no ODBC
> driver available
>
> others may be able to suggest additional reasons for using ADO. I would[/color]
have[color=blue]
> to have some _compelling_ need in order to use anything but DAO with a Jet
> database.
>
> Larry Linson
> Microsoft Access MVP
>
> "William Roberts" <williamr107@hotmail.com> wrote in message
> news:0zclb.23375$Ee6.17201@nwrddc01.gnilink.net...[color=green]
> > Hello
> > I am going to start making some of my queries in code. (VB in Access[/color][/color]
2000)[color=blue]
> .[color=green]
> > Should I use ADO or DAO? Does it make a big difference and why?
> >
> > Thanks
> > William Roberts
> >
> >[/color]
>
>[/color]