Why a query against DB2's Table works, but against DB2 View - doesn't?

[surotkin]

Hi everyone,
I use MS Access as a front-end database to run queries against DB2 tables and views.
When I use filter (criteria) in queries based on DB2 tables, it works fine. However, when I use the same queries based on DB2 views, it doesn't filer records. The filter (criteria) doesn't work for views!!!

Does anybody have any idea, why?

Any help appreciated.
surotkin

 

[lynchg]

I have no idea, but have you tried creating an Access query that is a staright select from the view. Then creating another query off of that one where you enter your criteria.

It's worth a try.

 

[surotkin]

Hi lynchg,
Thanks for your response.

I have solved the problem recently myself.
I deleted links to DB2 objects, then I recreated the links.
It works now.

Thanks.
surotkin