Re: MS Access DAO -> ADO.NET Migration

I had your problem basically and am working at the moment to transfer
existing Access 97 databases, (with data), to SQL Server Everywhere, the
new/old database referred to by William (Bill) Vaughn. He suggested to me
that I use this new database for .NET 2005 development where the DataBase
requirements are similar to what I had in a VB6/Access97 desktop
application.

I am working on an app to migrate the Access 97 database to the SSEv
database and it is going relatively smoothly. Although, there are some
problems as I have defined in a post a little above yours.

I do not expect to edit relationships within the predefined database OR
re-define existing tables BUT, I have seen reference to code which can do
this.

If you try to find code samples - do yourself a favor, use Google as William
(Bill) Vaughn valiantly suggests. Microsoft help is, in many cases,
gibberish, which will not solve your query and will just make you angry and
frustrated. I wonder when Microsoft will catch on a construct a serious
library of code samples instead of the meager offerings available.

If any of the Google search results take you to forums which require that
you 'join', be careful. Some of these forums even want you to pay to join
without you knowing if a solution is actually available there.

Be careful about using Sponsored Links as these must have some financial
incentives involved otherwise they would not be there. It costs money to put
a Sponsored Link on a Google Search result page. Every click means that
money is earned by Google.

If you want to go down this route, use 'Reply to Sender' as well as 'Reply
to group' and I will send you my code which is a near completed application
in VB.NET. I do not want to post my email address here.

I need an exchange of info and opinions from another programmer who is
having similar, if not identical problems.

Garry


<moomoofatcow@xxxxxxxxxxx> wrote in message
news:1163796070.268114.323610@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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: MS Access DAO -> ADO.NET Migration
    ... does build the SSCE database, just some of the definitions are not included. ... Microsoft chose to change the name from SQL Server ... put a Sponsored Link on a Google Search result page. ... DAO has methods and properties that are Access ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: To add search in my page
    ... lak wrote: ... it tells to use the google search. ... I am using intra-net system. ... You'll need to build a search engine which examines the generated html for every page, parses it into the appropriate words, catalogs those words in a database, then matches the search arguments to each word. ...
    (comp.lang.php)
  • Not updating Access DB
    ... ran a Google search for my problem and here is what ... enter information into your database ... >yourself to be a user of the High Performance Club by ... >lastname email Purchased style Username Age Date year ...
    (microsoft.public.frontpage.programming)
  • Creating a Knowledge Base
    ... started creating an SQL knowledge base that eventually I ... can write a .net desktop application to interface with ... the Database, what keywords I should use, how to create ... Any help would be greatly appreciated...a Google search ...
    (microsoft.public.sqlserver.server)
  • Re: Import Text with existing schema.ini file utility
    ... the database engine looks for schema.ini. ... As far as I know it's not possible to specify schema.ini in SQL; ... DAO is specifically designed to work with the Jet ... >> oDB.Execute strSQL ...
    (microsoft.public.access.modulesdaovba)