471,090 Members | 1,557 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,090 software developers and data experts.

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 2677
32,346 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

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.