Cannot find the right table when connecting from Oracle to Access

marcgu
marcgu used Ask the Experts™
on
Hi!

I have successfully managed to create a link to one specfic table in a database by using this way in MS Access 2007 but fail to do it for another one.


In both cases I use this way in MS access 2007. .External Data - more -odbc databse link to the data source by creating a linked table - data source for the machine. Then I select the source and click ok and get to a ODBC driver connect where I enter user name and  password.

Then the dialouge appears where I am able to pick tabels. For the database where I dont have all permissions to all tabels and views I get to pick the correct tables. However, from the database where I only have read right to one table I get a list of houndres of tables. The attached picture shows some of them.


Some start with: EXFS.SYS....
OTHERS WITH: LSLSYS.... OR  MDSYS..., PUBLIC...



It´s important to know that I can easily connect to the table with the same user name and password by using sql  developer.

My questions are as follows:

1. I am able to make this kind of connection if I only have read permissions to a table?
2. Is there any clue to which table I should access, because when I browse the long list I cannot find any traces of the user name I have nor the table name I have access to by sql developer.

Best regards

Marcus


tabels-to-access.png
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Retired IT Professional
Commented:
The image atached shows only the PUBLIC account files.
Can you see any table that starts with other username account, that you supplied his password?

Author

Commented:
Thanks! You made me look at another place.
Hamed NasrRetired IT Professional

Commented:
Welcome!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial