How do I get rid of "ODBC --call failed" error in MS Access 2007 Linked Table Manager?
Posted on 2009-12-30
I'm running Access 2007, linking to Oracle datasources (Oracle 10g). This error happens in the Llinked Table Manager. Usually when I select a linked table, and also select "Always prompt for new location".... then I get "ODBC -- call failed." I'm on Office 2007 SP2. This seems to have been a problem with Access 2007 from the get-go, though I've been using it for a while now. I'm using an ACCDB database. Any ideas on how to fix this? Thanks,