We help IT Professionals succeed at work.
Get Started

Access 2003 - ODBC --Call failed,

775 Views
Last Modified: 2013-11-29

I use Access as a front end for reporting out of our ERP system. I have a load of tables setup via ODBC which connect to the data and help me run reports.

Recently I have been recieving the error:
ODBC --Call failed
          OK
MS Access cant open the table in datasheet view
          OK
A temporary solution I have found to this problem is to right click on a table --> Linked table manager and update the tables I plan to use. This will only work for a few minutes and I will start receiving this error again.
This solution also wont work for end users as all they do is click on the report they were after (Then complain when they recieve the "ODBC Call Failed" error)

I could also take copies of the tables (speed up report speeds) but this is only possible in certain situations (when the user doesn't require live data)

I have setup some software called Dataflex to access the information from our ERP system.
Under Administrative Tools --> Data Sources(ODBC) --> I have setup a datasource DataFlex Data 32 using hte dataflex driver linking to the path: k:\cba2000\data;k:\cba2000\data\co1
Dataflex has been working perfect for the last 4 years or so and I have no problem using CBA to access these files
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 2 Answers and 14 Comments.
See Answers
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE