ACC97: Select Statements in Queries Do Not Work (230559)
The information in this article applies to:
This article was previously published under Q230559 Advanced: Requires expert coding, interoperability, and multiuser skills.
SYMPTOMS
Two logically identical queries provide different result sets under certain circumstances.
CAUSE
A SQL statement with multiple field criteria that are based on highly non-selective indexes will not return any records if all of the following conditions are true:
- Criteria are not translated into expressions during the compile stage of the query optimizer.
- Criteria contain a combination of AND and OR.
- Criteria contain at least 1 nonindexed field.
- Number of records in table > ~200.
RESOLUTION
Obtain Microsoft Jet Database Engine 3.51 Service Pack 2, which is available from the Microsoft Download Center.
For information on how to obtain Microsoft Jet Database 3.51 Service Pack 2, please see the following article in the Microsoft Knowledge Base:
172733 ACC97: Updated Version of Microsoft Jet 3.5 Available for Download
STATUS
Microsoft has confirmed this to be a problem in Microsoft Access 97. This problem no longer occurs in Microsoft Jet Database Engine 3.51 Service Pack 2.
Modification Type: | Major | Last Reviewed: | 9/25/2003 |
---|
Keywords: | kbbug kbfix KB230559 |
---|
|