link oracle table from access database

[amortillaro]

Hi all, I'm new in oracle, this is my issue.
I created in oracle9 a new table. Then in an access database I tried to link that oracle table trought ODBC and a datasource created to my oracle db but not all the tables for the user appears listed in the "link tables listbox". Is there anything else I should do in term of privileges or some other permiss. If so can you give me the steps for that?
Thanks in advance...

 

[CatherineDevlin]

Accessing the database through an ODBC datasource should, from the database's point of view, be identical to accessing it through a SQL*Plus window. Can you open a SQL*Plus window with the same username/password@instance as the datasource and verify that they appear in ALL_TABLES?

 

[amortillaro]

yes actually I can list the records from sql*plus, the thing is that in the listbox for select the table 2 link, in access, just two of the tables are listed.
As user name I'm using "system" I don't know where else to look for....