Article ID: 225422 - View products that this article applies to.
This article was previously published under Q225422
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
You may get different results running a query that contains a WHERE clause and an outer join to another query on a local table than you get on an linked ODBC table. This happens even though the local table and the linked table contain the same data.
When the tables are local, the WHERE clause is processed before the outer join. However, when the tables are linked, the queries are combined into a single SQL statement and the WHERE clause is processed after the outer join.
To prevent this problem, the version of Microsoft Jet must be 3.51.2723.0 or later. To obtain a new version of Jet, install Microsoft Jet 3.51 Service Pack 2.
For additional information about Microsoft Jet 3.51 Service Pack 2, please see the following article in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/172733/EN-US/ )Updated Version of Microsoft Jet 3.5 Available for Download
Steps to Reproduce Behavior
Article ID: 225422 - Last Review: October 20, 2013 - Revision: 3.1