Using Access (MS Office 365 Pro Plus) I created a linked table to Oracle with no issues. When I double click on the table name, I get the error "ODBC--call failed". I click "OK", and the table displays. It contains the correct column names, and the correct number of records. However, every value in every column is #Name?.
The really odd thing is that if I click on the filter button in each column heading, I see a list of all the correct values for that column! If I select one, or a few, I get the error "ODBC--call failed", and then a display of the correct number of rows that should be there, but again, all the values are just #Name?.
Any idea what causes this, and how I can fix it?