Solved

Cannot find the right table when connecting from Oracle to Access

Posted on 2011-09-03
3
379 Views
Last Modified: 2012-05-12
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
0
Comment
Question by:marcgu
  • 2
3 Comments
 
LVL 30

Accepted Solution

by:
hnasr earned 500 total points
ID: 36480003
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?

0
 

Author Closing Comment

by:marcgu
ID: 36480373
Thanks! You made me look at another place.
0
 
LVL 30

Expert Comment

by:hnasr
ID: 36480474
Welcome!
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question