criteria on nodbc, NAV - MS Access

j.marselo

I'm diggin to this forum to find a or some solution(s) on a problem.

I am using NAV 4 sp2, and I'm doing nodbc, link table from NAV to MS Access.
In certain query, I need to put a filter on SO No. , however it results an error.
The error message is "ODBC --- call failed"
But if I filter or dates using "Between [starting date?] and [ending date?]" - it works.

Is there any advice on this?
Thank you.

http://www.mibuso.com/forum/viewtopic.php?p=103437#103437

j.marselo

so ... I think, let ms access draws as many lines as it processes. the use form filter in the query result.
that's the way out I used in my case.

any other opinion?

cschiffert

I believe there is a hotfix rollup for this error. You have to submit a request from Microsoft for Article 927113.