Re: Why don't I use DAO?

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Bill Thompson (billt61_at_rgv.rr.com)
Date: 09/09/04 

Date: Thu, 9 Sep 2004 09:40:04 -0500

"Anders Eriksson" <anders.eriksson@morateknikutveckling.se> wrote in message
news:k2nzuz1zczma.dlg@morateknikutveckling.se...
> On Thu, 9 Sep 2004 14:51:53 +0800, LeeTow wrote:
>
> > I create a single document using vc,and step 2 of 6 I select "Database
view
> > with file support" and press "data Source",and I select DAO and select
> > my database for access 2000,but it display "Unrecongnize database
format",
> > who could tell me how to solve this problem?
>
> The Application Wizard can only read Jet 3.5 databases! I.e. Access 97 or
> earlier.
>
> You can however manually create code so that you can read/write Jet 4.0
> (Access 2000) databases. See this KB:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;236991
>
> NB! Unless this is a minor application I really advice you to move away
> from DAO. Microsoft has stopped supporting DAO and is now pushing
> ADO/OleDB. ADO is simplified a lot by using Mr. Carlos Antollini see his
> articles at CodeProject:
>
> A set of ADO Classes - Version 2.10
> http://www.codeproject.com/database/caaadoclass1.asp
>
> A Set of ADOX Classes
> http://www.codeproject.com/database/caaadoxclass.asp
>
> ADO Connection Strings
> http://www.codeproject.com/database/connectionstrings.asp
>
>
> // Anders

After you have become acquainted with ADO using the above references, you
can get more information by reading the compiled HTML help file ADO210.CHM.
If you don't have this file, you can get it by installing Microsoft Office
2000 Service Release 1/1a (SR-1/SR-1a). Which I found out at this link:
http://support.microsoft.com/default.aspx?kbid=249065

The CHM file is full of sample code, and has many useful tips, e.g. the Find
method won't work correctly unless it starts with a valid record position.

Relevant Pages

  • Fujitsu ADO Data access guidance needed
    ... Could someone please provide some sample code or point me to a good tutorial or reference material regarding the use of ADO to access Microsoft SQL server, ... I think I saw a post here stating that ADO is better. ...
    (comp.lang.cobol)
  • Re: Cannot read data from Access 2007 database
    ... I'm using ADO to acces the Access database. ... some very simple sample code of mine that attemps to read the "DATE" ... description is always "Unknown error 0x800A0CC1" ... Please reply to the newsgroup. ...
    (microsoft.public.data.ado)
  • Re: Collate information from different files via a macro
    ... See Ron de Bruin's sample code at: ... Copy a range from closed workbooks (ADO) ...
    (microsoft.public.excel.programming)
  • Re: Insert binary file content to DB
    ... > Database: MS-SQL and Access ... With ADO it is GetChunk and AppendChunk or Parameters. ... >>> Can someone show me a sample code on how I can insert a binary data ...
    (microsoft.public.vb.database.ado)
  • Re: Why dont I use DAO?
    ... databases. ... Microsoft has stopped supporting DAO and is now pushing ... ADO is simplified a lot by using Mr. Carlos Antollini see his ... A set of ADO Classes - Version 2.10 ...
    (microsoft.public.vc.mfc)