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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.