Need help linking oracle tables in MS Access

Question

I am having some issues connection to an oracle DB using MS Access.

If I use SQL Developer to connect to the Oracle DB I see pretty much every table and view in the DB however when I connect using MS Access I only get a selected few.

I tough it was because the user didn't have Select privileges on the tables I need so I requested the privilege and after a moth of waiting I finally got it but I still cant see the tables on the Access tool.

This is what I see on SQL Developer vs MS access. I need SFMFG.PWUI_CHAR_DEF_EXT to show on access table manager. Any help to solve this mystery is greatly appreciated.

Answer 1

Using Access 2010, if I select External Data ==> ODBC Database ==> Link to the datasource by creating a linked table, I get a windows dialogue of all the available datasources. When I log in to the one I want, I see the names of all the tables I am authorized to select from.

The Linked Table Manager only shows the tables for which there are existing links.