468,766 Members | 1,312 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,766 developers. It's quick & easy.

ODBC Call Failed Error for Query using Linked Tables


Expand|Select|Wrap|Line Numbers

When I run this query from MS Access, I get an 'ODBC Call Failed' error. I have created linked tables in access for the tables used in this query.

Anybody able to help me on this ?

Thanks in Advance.
Jul 23 '07 #1
1 2582
32,130 Expert Mod 16PB
It's almost certainly nothing to do with your query (SQL) per se.
This is an ODBC problem. This is as varied as there are ODBC drivers out there, but I'd start by trying to open each of the tables in your query to see which of them has a problem. From there it's down to whoever at your company is responsible for the ODBC setup I'm afraid.
Jul 24 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

3 posts views Thread by Ian | last post: by
8 posts views Thread by Jimbo | last post: by
reply views Thread by Cunfshon | last post: by
reply views Thread by Igor | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.