MS Access queries don't work with parameters using NODBC

Faberman

Hi,

We have recently upgraded to Navision v4.0 SP3 and historically I have constructed MS Access dBs which link to Navision tables as ODBC sources so that I can query them.
The queries are usually simple SELECT statements in which parameters are passed to the query using a form.
Now I am trying to do the same with NODBC and I find that I can only use dates as parameters while Strings and Integers cause the dreaded "ODBC - call failed" message to appear.

For example :

SELECT Sales_Invoice_Header.No_, Sales_Invoice_Header.Sell_to_Customer_No_, Sales_Invoice_Header.Bill_to_Name, Sales_Invoice_Header.Invoice_Value, Sales_Invoice_Header.Posting_Tax_Point_Date
FROM Sales_Invoice_Header
WHERE (((Sales_Invoice_Header.Sell_to_Customer_No_)="5273") AND ((Sales_Invoice_Header.Posting_Tax_Point_Date) Between [forms]![x]![x] And [forms]![x]![y]));

If I run this as is, it works fine.
(with dates as 01/01/07 format)

If I change the "5273" to, say, [forms]![form1]![accno] the ODBC call fails.
I t makes no difference whether a String is passed or an Integer, the query fails.
I have found the same problem using MS Access 2000 and 2007, and I have tried it on several machines, which leads me to believe that it is an NODBC driver issue.

The driver options are configured thus :

Identifiers : a-z,A-Z,0-9;_
Language : Auto (Windows Language) i.e. United Kingdom
Option Field Type : Text
Commit Cache : Yep
DBMS Cache (KB) : 8000
Read Only : Yep

I'm pointing to a server, TCP net type, username & password is in, also the company name etc. etc.

Nothing appears to be any different from before when I used the C/ODBC driver.

Can anyone help???????

](*,)

Can anyone explain what has changed or what needs to be changed to get this working again?