Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: Microsoft Jet Does Not Pass WHERE Clause to ODBC Data Source
Article ID: 282604 - View products that this article applies to.
This article was previously published under Q282604
Advanced: Requires expert coding, interoperability, and multiuser skills.
This article applies only to a Microsoft Access database (.mdb).
When you use Access 2000 Service Release 1 (SR-1) with Microsoft Jet 4.0 Service Pack 5 (SP5) to query tables linked from two separate databases on the same server, you may find that Jet does not pass the WHERE clause parameters to the ODBC data source when both of the following are true:
Jet does not send the WHERE clause for one or for both queried tables. This causes the server to return all rows to the client.
To resolve this problem, install the latest Jet 4.0 service pack. For additional information about how to obtain and how to install the latest Jet 4.0 service pack, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/239114/ )How To: Obtain the Latest Service Pack for the Microsoft Jet 4.0 Database Engine
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first fixed in Jet 4.0 Service Pack 6 (SP6).
Steps to Reproduce the Behavior