?
Solved

Cannot find the right table when connecting from Oracle to Access

Posted on 2011-09-03
3
Medium Priority
?
392 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 31

Accepted Solution

by:
hnasr earned 1500 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 31

Expert Comment

by:hnasr
ID: 36480474
Welcome!
0

Featured Post

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

In a use case, a user needs to close an opened report by simply pressing the Escape (Esc) key. This can be done by adding macro code in Report_KeyPress or Report_KeyDown event.
Beware when using the ListIndex and the Column() properties of a listbox in Access 2007.  A bug has been identified in the Access 2007 listbox code which can cause the .ListIndex property to return a -1, and the .Columns(#) property to return a NULL…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Suggested Courses
Course of the Month7 days, 2 hours left to enroll

592 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