Re: Help with converting DAO to ADO

ADO.NET is database access for the DotNet environment, and used with VB.NET,
C#, and other DotNet languages. You cannot (at least not without jumping
through flaming hoops, if you can at all) migrate an Access database to
ADO.NET, not through Access 2003. There are, as yet, unannounced features
and functions for the next version, and AFAICR ADO.NET has not been
announced.

Larry Linson
Microsoft Access MVP


"robert d via AccessMonster.com" <u6836@uwe> wrote in message
news:5c04c76df5092@xxxxxx
The first link to the msdn article (revised in September of 2005) states
under a heading entitled: Obsolete Data Access Technologies.

Obsolete technologies are technologies that have not been enhanced or
updated
in several product releases and that will be excluded from future product
releases. Do not use these technologies when you write new applications.
When
you modify existing applications that are written using these
technologies,
consider migrating those applications to ADO.NET.

Data Access Objects (DAO): DAO provides access to JET (Access) databases.
This API can be used from Microsoft Visual Basic®, Microsoft Visual C++®,
and
scripting languages. It was included with Microsoft Office 2000 and Office
XP.
DAO 3.6 is the final version of this technology. It will not be available
on
the 64-bit Windows operating system.


Can I migrate to ADO.NET even if my application remains a desktop
application.
?

Lyle Fairfield wrote:
Do you think it serves any purpose to clutter the newsgroup with old
quotes
that _appear to_ but, in fact, no longer _do_ contradict Allen Browne's
perfectly accurate comments about the "classic ADO" of which you are the
"world's greatest fan" versus ADO.NET and using DAO when the database
engine
is Jet?

http://msdn.microsoft.com/data/mdac/default.aspx?pull=/library/en-us/dnmdac/html/data_mdacroadmap.asp

To be completely honest, Lyle, you should write "Microsoft said" (past
tense).

http://msdn.microsoft.com/data/mdac/default.aspx?pull=/library/en-us/dnmdac/html/data_mdacroadmap.asp

Larry Linson
Microsoft Access MVP

--
Message posted via http://www.accessmonster.com


.

Relevant Pages

  • Re: Help with converting DAO to ADO
    ... As a newcomer to Access and to the whole database development scene, ... became more interested in the underlying technologies that are used to ... In researching it, I found that DAO vs ADO, .mdb vs ADP, etc. ...
    (comp.databases.ms-access)
  • Re: Timer to Enable/Disable a Button
    ... I am having a problem with a MS Access 2000 Database that I ... Public Function DatetoNearestHourBAs Date ... Obsolete Data Access Technologies ... Data Access Objects (DAO): DAO provides access to JET databases. ...
    (comp.databases.ms-access)
  • Re: ado vs.dao
    ... 'Classic' ADO is not being further developed either, ... > DAO is an older technology and it seems that it is not being updated. ... > versions and new technologies or if it has a relatively fixed life. ... >>> layer for any database engine. ...
    (microsoft.public.access.modulesdaovba)
  • CFP: CALL FOR CHAPTERS - Handbook of Research on Soft Computing Applications for Database Techno
    ... Proposals Submission Deadline: 8/20/2008 ... Handbook of Research on Soft Computing Applications for Database ... field of database technologies. ... The Handbook of Research on Soft Computing Applications for Database ...
    (comp.ai)
  • POS/ COGNOS/ CAREER POSITION/ OH
    ... repositories needed to support the Company's business objectives. ... *Proficient in Microsoft technologies, including MS Access, MS Office Suite. ... *Experience and understanding of application servers. ... *Experience and understanding of database servers. ...
    (comp.sys.ibm.as400.misc)