Re: Replacement for Dao

From: Roy Fine (rlfine_at_twt.obfuscate.net)
Date: 05/10/04

  • Next message: Roy Fine: "Re: Replacement for Dao" 
    Date: Sun, 9 May 2004 21:50:37 -0400

    Rajas,

    have you installed Jet 4, Service Pack 8. Here are a couple of links:

    http://support.microsoft.com/default.aspx?scid=kb;en-us;829558

    http://support.microsoft.com/default.aspx?scid=kb;en-us;825796

    regards
    roy fine

    "rajas" <rajas@cox.net> wrote in message
    news:EfAnc.19083$ph.708@fed1read07...
    > Roy,
    > Thanks for the input.
    >
    > The application (an MFC app) that I am looking at actually works well with
    > Access2000 - in fact the application checks to see if jet 4.0 is available
    > and uses AfxGetModuleState()->m_dwVersion = 0x0601; to work around the
    hard
    > coding in MFC. However, something in Office 2003 seems to break it.
    >
    > As I wrote earlier, the application uses Jet database or SQL server. I
    read
    > that Jet actually provides ADO support through its ODBC (I am still
    looking
    > through examples in ODBC for Autonumber - seems a pain with need for
    > multiple accessor macros , as well as BLOB support for large text
    strings -
    > was straight forward in Dao) and hence ODBC may perform better than ADO.
    > Have not made a decision yet - but looks like I need to real soon.
    >
    > "Roy Fine" <rlfine@twt.obfuscate.net> wrote in message
    > news:uouV1qSNEHA.892@TK2MSFTNGP09.phx.gbl...
    > > Rajas,
    > >
    > > you may have gotten a bit of bad info -- DAO still works, it is MFC that
    > is
    > > hardcoded to the DAO 3.5 version. DAO 3.6 works well with Jet 4
    database
    > > versions through Access 2000 for sure.
    > >
    > > If you want to move away from DAO, then you should seriously consider
    > ADO -
    > > there are capabilities in ADO and ADOX that match DAO, while the ODBC
    > > support is a bit weak (like not being able to create autonumber column,
    > and
    > > not being able to access the @@IDENTITY column, etc...)
    > >
    > > regards
    > > roy fine
    > >
    > >
    > > "rajas" <rajas@cox.net> wrote in message
    > > news:H2tmc.17865$ph.13348@fed1read07...
    > > > Hello,
    > > >
    > > > I need to 'update' an application that uses MFC Dao database classes -
    > it
    > > > appears that this will not work in newer Windows & no longer
    supported.
    > > The
    > > > application uses Access or SQL server depending on the circumstances.
    > > >
    > > > What is the best alternative - Still need to use VC 6 (not .Net).
    > Need
    > > to
    > > > taking into account learning curve & 'longevity' of support.
    > Performance
    > > is
    > > > also a consideration - though secondary. Most ADO examples in MSDN
    > > seem
    > > > to be .Net or VB, and OLE DB examples are even more limited.
    > > >
    > > > I would appreciate any and all input. If there is already a place
    where
    > > > this has been discussed - I would appreciate if someone would point me
    > to
    > > > it.
    > > >
    > > > Thanks
    > > >
    > > >
    > >
    > >
    >
    >

  • Next message: Roy Fine: "Re: Replacement for Dao"

    Relevant Pages

    • Re: [Access2003, VBA] Use DAO or ADO?
      ... One of the reasons my clients preferred Access / Jet / ODBC was that they ... Autonumber or its server equivalent and could have been shown to the users ... real world of development, Dot Net", ADO has been superceded by ADO.NET ...
      (comp.databases.ms-access)
    • Re: [Access2003, VBA] Use DAO or ADO?
      ... ODBC, whatever the back end. ... to a jet backend to open a ado recordset. ... customers want/need sql server and another wants to use MySql. ...
      (comp.databases.ms-access)
    • Re: opening ole db databases in access
      ... Ok Brendan, thanks. ... If your data source is not supported by Jet and there ... > is no ODBC driver, then the only way to access the data will be via ADO, ...
      (microsoft.public.access.externaldata)
    • Re: ODBC Refresh Interval
      ... isn't a huge deal most of the time), is that I can't rely on FindFirst! ... a form bound to an ODBC linked table, ... with Jet x.y, or Jet y.z, or whatever. ... ADO is dead, of course. ...
      (comp.databases.ms-access)
    • Re: How to enforce subtypes/supertypes in Access 2000?
      ... DAO is the native object model for Jet databases and, as such, is the ... ever need ADO. ... Private Sub SetContactType() ...
      (microsoft.public.access.tablesdbdesign)