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
MS Access cant open the table in datasheet view
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