Solved

Cannot find the right table when connecting from Oracle to Access

Posted on 2011-09-03
3
382 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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…

687 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