DAO Support

[George]

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.

 

[Paul Overway]

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

 

[Eddy]

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]

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?

 

[Van T. Dinh]

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