Hi

now that MS has indicated that ADO is the future, have
they actually said when they'll terminate the support for
DAO? Can someone point me to some related webpages?

TIA.

ADO has been superceded by ADO.Net. Neverthless, DAO is still being
supported. AFAIK, Microsoft has made no announcements concerning
discontinuing support for DAO.

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com


"George" <(E-Mail Removed)> wrote in message
news:0d8f01c37945$1c8d4330$(E-Mail Removed)...
> Hi
>
> now that MS has indicated that ADO is the future, have
> they actually said when they'll terminate the support for
> DAO? Can someone point me to some related webpages?
>
> TIA.

DAO is still supported by Office 2000 & XP. My guess is that DAO will be
ended when Office XP becomes obsolete. My personal opinion is to upgrade
whatever you are doing from DAO to ADO, because ADO runs faster and supports
MSDE (Desktop version of SQL).

"Paul Overway" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó
news:(E-Mail Removed)...
> ADO has been superceded by ADO.Net. Neverthless, DAO is still being
> supported. AFAIK, Microsoft has made no announcements concerning
> discontinuing support for DAO.
>
> --
> Paul Overway
> Logico Solutions, LLC
> www.logico-solutions.com
>
>
> "George" <(E-Mail Removed)> wrote in message
> news:0d8f01c37945$1c8d4330$(E-Mail Removed)...
> > Hi
> >
> > now that MS has indicated that ADO is the future, have
> > they actually said when they'll terminate the support for
> > DAO? Can someone point me to some related webpages?
> >
> > TIA.
>
>

DAO is supported in Access 2003...and I expect that it will be in the next
version after. Beyond that, I'm not sure. Nevertheless, ADO is NOT faster
than DAO. ADO is a wrapper for calls to database drivers, whereas DAO is a
database engine/driver. Your statement is equivalent to saying that it
would be faster for a fluently bilingual person (English/Spanish) wanting to
communicate to someone else who speaks Spanish to speak through a
translator. Why waste time with a translator when you can speak directly?

--
Paul Overway
Logico Solutions, LLC
www.logico-solutions.com


"Eddy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> DAO is still supported by Office 2000 & XP. My guess is that DAO will be
> ended when Office XP becomes obsolete. My personal opinion is to upgrade
> whatever you are doing from DAO to ADO, because ADO runs faster and
supports
> MSDE (Desktop version of SQL).
>
> "Paul Overway" <(E-Mail Removed)> ¼¶¼g©ó¶l¥ó
> news:(E-Mail Removed)...
> > ADO has been superceded by ADO.Net. Neverthless, DAO is still being
> > supported. AFAIK, Microsoft has made no announcements concerning
> > discontinuing support for DAO.
> >
> > --
> > Paul Overway
> > Logico Solutions, LLC
> > www.logico-solutions.com
> >
> >
> > "George" <(E-Mail Removed)> wrote in message
> > news:0d8f01c37945$1c8d4330$(E-Mail Removed)...
> > > Hi
> > >
> > > now that MS has indicated that ADO is the future, have
> > > they actually said when they'll terminate the support for
> > > DAO? Can someone point me to some related webpages?
> > >
> > > TIA.
> >
> >
>
>

OTOH, if you use JET Database Engine (which is still supported in A2003 and
at least 1 more version after A2003 AFAIK and JET is still much more popular
than MSDE, at least in Access), DAO is still much faster as per Paul's reply
and his translator example.

For more info., see MichKa's Web site:

http://www.trigeminal.com/usenet/usenet025.asp?1033

--
HTH
Van T. Dinh
MVP (Access)




"Eddy" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> DAO is still supported by Office 2000 & XP. My guess is that DAO will be
> ended when Office XP becomes obsolete. My personal opinion is to upgrade
> whatever you are doing from DAO to ADO, because ADO runs faster and
supports
> MSDE (Desktop version of SQL).
>