Re: problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

"Van T. Dinh" <VanThien.Dinh@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
news:OdXXJq6BHHA.3496@xxxxxxxxxxxxxxxxxxxx:

Access97 uses JET 3.5 engine so the correct version to use is
Microsoft.Jet.OLEDB.3.51, not the 4.0 version.

That makes no sense. The ADO version for Jet 4 is backward
compatible and can read and write older Jet formats (unless they are
replicated).

Now, if you're working in A97 and you want to use ADO, I don't know
what the situation is, but that's a nonsensical way to get to Jet
data in any version of Access, so I assumed that the host app is
*not* Access.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

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: 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)
  • Re: Use DAO or ADO?
    ... tables to a jet backend to open a ado recordset. ... will ALSO work for mysql, oracle and sql server if I take that sql ... engine that they don't understand who want to avoid Jet at all ...
    (comp.databases.ms-access)
  • Re: [Access2003, VBA] Use DAO or ADO?
    ... to a jet backend to open a ado recordset. ... Because one might have chosen to use ado in place dao in their application. ... You gain sql neutral code. ...
    (comp.databases.ms-access)
  • Re: [Access2003, VBA] Use DAO or ADO?
    ... tables to a jet backend to open a ado recordset. ... Because one might have chosen to use ado in place dao in their ... You gain sql neutral code. ... engine that they don't understand who want to avoid Jet at all ...
    (comp.databases.ms-access)