By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,806 Members | 1,457 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,806 IT Pros & Developers. It's quick & easy.

ODBC Call Failed Error for Query using Linked Tables

P: 19

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
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,489
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.