How to view linked tables

[Angel69]

I am taking over a database someone else created but is no longer here. The tables are linked to an external oracle database. I know the links exist because when I run a query it prompts me for my user name and password. However, the tables look like regular tables. There is no icon showing it's a linked table so I don't know which tables are actually linked and pulling from the Oracle database. How do I view this? TIA

ETA: BTW, the linked table manager icon on the ribbon is greyed out.

 

[Pat Hartman]

It sounds like the developer didn't leave the tables permanently linked. If you look, you will probably see code that creates the links when you log in and deletes them when you log off.

 

[namliam]

is it possible the creator used pass through QUERIES instead of tables?

 

[Angel69]

Unfortunately I'm not familiar with pass through queries. Is there an obvious way to figure it out? I did go under table dependencies and sure enough I do see tables that I recognize as the Oracle database tables and also see the icon that you normally see in table view when a table is linked.

 

[namliam]

In the properties you can find the connection it makes:
http://3.bp.blogspot.com/-Vdhyg7EB8WY/TqIY6iokHnI/AAAAAAAAArM/3Mv8xuvvJkI/s1600/Encrypt8.JPG

and you should just see the icon same as with the tables I guess

And offcourse another option is that the tables are hidden ... you can use them but cant see them (by default) depending on different versions you need to go into the database options and make them visible (someplace).... Google your version to find out exactly where (or search for the option yourself in the database options, shouldnt be too hard to find)

 

[Angel69]

The tables appear to be hidden. I found these these insructions to unhide "In Access 2007, click on the Office logo (the big circle in the upper left-hand corner), go into Access Options, select Access Options (at the bottom) and look at the properties for the Current Database. About half-way down, you should see Navigation. Click on the Navigation Options... button. There are display options in the bottom left-hand of the form that pops up."

I'm able to see and click on them but the icons and text are almost grey out compared to other tables in the view.

Thank you!

 

[namliam]

if you right click on the tables and go to options, you can uncheck the "Hide" option for the table that should return them to "normal"

Or you can leave them hidden and toggle them using the option so atleast they stay out of view for the "average" user.