A rookie MS ACCESS QUESTION

[MarkWilliamson]

There is a table within a MS ACCESS DB that is linked to an ORACLE table. How can I tell which table it is linked to ?

Thanks in advance to all who reply !!!

 

[ErnstJan]

You can see which tables are linked by the arrow left of the tabel name.

 

[MarkWilliamson]

Thank you. What I would like to find out is what ORACLE table the ACCESS table is linked to.

 

[DataChick]

If you open your Linked Table Manager (under Tools/Database Utilities in Access 2000) then it will show you all the tables you have linked and their sources.

For Oracle ODBC tables, it will show you the Data Source Name that the table is housed in.

The only problem is that if you change the name of the table after it's linked, the Linked Table Manager will not show you what the original table name was.

If anyone knows how to determine the original name of a linked ODBC table where the name has been changed, I am also curious about that.

Hope this helps you.

"The most likely way for the world to be destroyed, most experts agree, is by accident. That's where we come in; we're computer professionals. We cause accidents."
-Nathaniel Borenstein

 

[cheerio]

This can be done in Code.

eg

Public Sub Link_Source()
Dim db As DAO.Database
Dim tbl As DAO.TableDef

Set db = CurrentDb()

For Each tbl In db.TableDefs
   If tbl.Attributes = dbAttachedODBC Then
       Debug.Print tbl.Name, tbl.SourceTableName
   End If
Next
End Sub

You will need to reference the DAO library of Access 2k onwards.