ODBC link not filtering correctly

[apex1x]

Hi all,

I'm having an issue with ODBC connections within Access 2007 linked to an Oracle 9i backend where a filtered field (either through table dataset view or a query) filters to a completely different value than what was set.

For example:

There is a field [Field 1];if I filter for a value in [Field 1], such as "1009", the [Field 1] value returned might be "1002" or "1005".

The ODBC version is Oracle 10g (10.01.00.31).

Any ideas? Is this maybe an indexing issue or some sort of bug?

Thanks!

 

[dhookom]

Have you tried to see if you get the same results with a pass-through query? Can you share your actual SQL view?

Duane
Hook'D on Access
MS Access MVP