ODBC & MS Access

CSSMepps

Hello,
We use Navision 3.7. We do some custom reports pulling the Navision data into Access using CODBC 3.7. We have one problem with this process and hope someone can help us. We are unable to filter on dates using any of the standard Access data operands such as Between or > or <. We get an error "Invalid operand for operator". We can access the date field using this criteria: Like "8/*/04" or like "9/*/04" or like "10/*/04"... you get the picture. Our Navision provider does not have this problem on their test database, but they're running WXP/Office 2003, while we are W2K/Office2K. Also, I only have limited permissions, while they are a Super User. Any help on this would be greatly appreciated.

j.marselo

I'm diggin to this forum to find a or some solution(s) for similar issue.
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.

parallel post

j.marselo

this is a parallel post of another post.

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?

Faberman

This is more of a "I've got that problem too" kind of post - if you see my "MS Access queries don't work with parameters using NODBC" post I have the same problem (as J.Marselo) using the - forms![x]![y] - notation to pass String and Integer parameters to MS Access queries on Nav v4 SP3.
Dates, on the other hand, work just fine.

Has anyone found a solution or any articles so I can read-up on resolving this issue?

Any advice will be greatly appreciated.

[-o<