Issue Creating link to Oracle Table

[MSAccessRookie]

Greetings to all.

I encountered an interesting issue on a project today. We have an MS Access 2010 Database that uses Local Tables, External MS Access Tables, and ODBC Linked Oracle Tables (Accessed for Read Only). The unsual issue occurs with the ODBC Linked Oracle Tables.

One of the more important aspects of the project is to modify the ODBC Links to point to upgraded Oracle Database Tables. Up until today, all of the Links had been able to be remediated with a simple refresh and test.

This morning, however, it was determined that one of the Database Tables did not exist in the Schema. Instead, it was an Oracle Synonym for a Table that existed in a different Schema. We believe that we have the proper authorization for access to all of the Schemas involved, and despite this fact, MS Access was unable to link to the Table properly.

Has anyone encountered a situation like this before?

-- Rookie

 

[jdraw]

No direct experience with the situation, but it seems that there has been a change to Oracle and it isn't just a relink and carry on. Have you had this situation previously? Was there anything "extra/different" done on the Oracle end since your last successful session?