MS Access DAO -> ADO.NET Migration

I have an VB6 program that I wrote that access Microsoft Access
databases using DAO. DAO has methods and properties that are Access
specific (such as viewing and editing relationships or indexes on the
tables) I want to write a new version of the program in VB 2005, and I
want to use ADO.NET to access the data. Are there ways of changing the
indexes or relationships of the MS Access database using ADO.NET? Or do
I still need to use DAO to perform these operations?

As a side note, with a few tests that I've done already with some
queries, it seems like DAO is much faster than ADO.NET at running
queries and returning results. I am using the DataReader...does anyone
have any information about the differences etc? Thanks in advance...

.

Relevant Pages

  • Re: Access 2000 to 2003 Conversion
    ... DAO 3.5x Object Library. ... and any obsolete DAO 2.x syntax updated. ... > Should you try to convert all your databases from Access 2000 to ... > Conversion White Papers. ...
    (microsoft.public.access.conversion)
  • Re: Query performance MS-Access vs. SQL-server 2000
    ... > between the two alternatives is the use of DAO vs ADO: ... This may be due to the cursor type/location you chose to use in ADO. ... which was designed to work directly with Jet databases. ...
    (microsoft.public.sqlserver.programming)
  • Re: Me.Recordset -> DoCmd.RunSQL "UPDATE ...............
    ... DAO is the preferred library for interacting with Jet database engine. ... primary method by which data are manipulated in ACCESS databases since ... >> the form based on DAO recordset SQL statement: ... >> form's Recordsource to the SQL statement itself ("SELECT * FROM ...
    (microsoft.public.access.modulesdaovba)
  • Re: Why not use DAO?
    ... interface for working with JET databases. ... discussion about that (DAO was also faster as classic ADO) ... DAO is especially made and optimized for ACCESS database ADO is a more ... universal provider so ofcourse DAO wil outperform ADO in most ...
    (microsoft.public.dotnet.languages.vb)
  • Re: How to tell if application object is used...
    ... Granny Spitz via AccessMonster.com wrote: ... I could speculate that Access and databases have little or no direct ... It's DAO that works with the db and Access simply gives us ... the pointer to it will still have properties. ...
    (comp.databases.ms-access)