troubleshooting Question

MS Access query runs ok, report shows error: ODBC--Call Failed

Avatar of TheUndecider
TheUndeciderFlag for United States of America asked on
Microsoft AccessMicrosoft SQL Server
2 Comments2 Solutions871 ViewsLast Modified:
Hi, I have a MS Access 2000 database as my front end with a SQL Server 2000 database as my back end.  All the access tables are linked to the ones in the SQL database.

My problem is that I have a set of reports that months ago, they were printing fine.  However, now when I try to run them, I get a "ODBC--Call Failed" error.  This error has only the exclamation icon, a help and a OK button.  It doesn't give me any error number or any other message, just the line mentioned above.

The weirdest part is that when I run the Access query that acts as these report record source it runs fine and fast.  

The query selects a customer from my customers table and some orders from the orders table.  I have a 1 to many relationship between these 2 tables.  After I select the fields I need, I group them by first of customerID to get only 1 record.  The query does show that record when I run it.  The report gets stopped by the odbc error.

I've tried to change the ODBC timeout (currently is at 60) from 0 to 90 with no results.

I have temporarily deleted everything from one of these reports (except its data source) and the error  still shows up.

I've also used the link table manager and updated the mentioned tables in case they were different than the SQL ones and did not help.

What I don't understand is why the query runs perfectly if I run it by itself, but when I ran the report it shows the error.


Any help would be appreciated it.
ASKER CERTIFIED SOLUTION
InnovativeLogic

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros