ODBC Call Failed

[rjmdt]

I have a append query that when it runs I get a "ODBC call failed error", when I click ok I get another screen that says "ODBC Interface[ODBC Engine] The data type is invalid for the expression" . I just put on a new patch for the ODBC Engine, but I can't track down which expression could be causing the problem, or whether it is something about the ODBC.

I would appreciate any help

Thanks

RJ

 

[hermanlaksko]

I assume that you odbc is a table on an SQL-server ?

Try to enter your data directly into the odbc table in your access base, if the table recieves the data ok then the problem is in the form.
My guess is that the table will not accept any data most likely there is no key-fiels in the table.

Go to you enterprice mgr and fix this.