Re: problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0
- From: "Van T. Dinh" <VanThien.Dinh@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 14 Nov 2006 16:05:39 +1100
Access97 uses JET 3.5 engine so the correct version to use is
Microsoft.Jet.OLEDB.3.51, not the 4.0 version.
--
HTH
Van T. Dinh
MVP (Access)
"JackChiou" <JackChiou@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:93AB9661-D908-416B-ABEB-DF019CF2DDF3@xxxxxxxxxxxxxxxx
Hi everyone,
I am using ADO with Microsoft.Jet.OLEDB.4.0 to connect to the Access97
database. The problem is every time when I use WHERE clause with
duplicated
numerical value, it will fail....
For Example:
RecordSet.Open("SELECT * FROM xxxxx WHERE yyyyy = 1",
m_pConnection,
adOpenStatic,
adLockOptimistic,
adCmdUnknown);
(if field yyyyy is Index Yes with Duplicates OK, it will catch error.)
The error message shows:
ADORecordset error, error code =80004005, code meaning = Unspecified error
It's only happen on Microsoft.Jet.OLEDB.4.0, If I use other provider like
MSDASQL or Microsoft.Jet.OLEDB.3.51 then it's working fine. I also had
tried
to convert the database from Access97 to Access2000 and upgrade the ADO
and
Microsoft.Jet.OLEDB.4.0 to the latest version but still the same. It feels
like Jet.OLEDB.4.0 doesn' like any duplicated numerical value???!!
I have been working on this for 2 weeks already but still no luck, getting
so frustrated now so please help me!! Thanks!!!
-Jack
.
- Follow-Ups:
- Re: problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0
- From: David W. Fenton
- Re: problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0
- Prev by Date: Re: Using DISTINCT and TOP
- Next by Date: Re: Random Record Selection
- Previous by thread: Re: Using DISTINCT and TOP
- Next by thread: Re: problem with WHERE clause when using Microsoft.Jet.OLEDB.4.0
- Index(es):
Relevant Pages
|
