MS Access query runs ok, report shows error: ODBC--Call Failed
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.
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.