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.