ODBC -- Call Failed error

[Coffee]

Hello,



i have linked a table into Accesss 2003 and the connection works fine. i can open the table and all data is returned. however when i query it in SQL i get the "ODBC--call failed." error pop up. everything in the SQL is refereced fine and if i change the table name to a local one it querys fine, it just wont query the linked one even though all the data is there and working fine?

help please

[ajetrumpet]

you'll get a million hits if you google it, my friend.

[Coffee]

they are all for the table/data not importing, but mine is importing. just sql wont work

i think i have two many AND, OR conditions on 1 SQL Statement could this do it?

[boblarson]

Are any of the linked SQL Server tables that you are using in the SQL statement SQL Views instead of the tables?

Also, what is the SQL for the query?