[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Cannot find the right table when connecting from Oracle to Access

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

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Question has a verified solution.

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

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.
Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
Suggested Courses

834 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