ODBC Call Failed - ORA 01013 in Access 2010

[kawi6rr]

We've been upgraded to Access 2010 recently and now I'm unable to create a link to our tables on our Oracle databse.

Orage 10g driver
Access 2010



I"m going through the the steps
1) External Data
2) ODBC Database
3) Link to the datasource
4) Select my ODBC connection

This connection is valid in step 4 I've used it before and still use it. A few of our people are still on older versions of access and we can make those link table connections but Access 2010 wont allow it. Any help is appreciated.

[rpeare]

did you try creating a new connection rather than using the 'old' connection. I'd delete the 'old' odbc driver and re-create it on the 2010 machines with the old name and see if that works.

[kawi6rr]

did you try creating a new connection rather than using the 'old' connection. I'd delete the 'old' odbc driver and re-create it on the 2010 machines with the old name and see if that works.

Thanks for the reply I'll try that Monday morning.