Locate Data Table

[Dsuperc]

Some time ago when I built a database, I linked a table to an excel spreadsheet. How do I find the name and location of that spreadsheet?

 

[namliam]

Linked table manager....

Regards

 

[Dsuperc]

LINKED TABLE

Thanks very much.
But here is a further problem.
I am using 2000 on a network.
When I go in to the add-in manager, the box is empty.
Is there a site I could download the add-in?

 

[WayneRyan]

D,

Failing that, there should be an entry in MSysObjects ...

Wayne

 

[namliam]

Sub LinkedTableCheck()
    Dim myPath As String
    Dim myConnect As String
    Dim myDB As Database
    Dim myTableDef As TableDef
    
    Set myDB = CurrentDb()

    For Each myTableDef In myDB.TableDefs
        If myTableDef.Attributes = dbAttachedTable Then Exit For
    Next
    myConnect = Mid(myTableDef.Connect, InStr(myTableDef.Connect, "=") + 1)
    myPath = Dir(myConnect)
    Debug.Print myTableDef.Name & ", " & myTableDef.Connect
    Debug.Print myConnect
    Debug.Print mytest
    If myPath = "" Then MsgBox ("related db not found")
End Sub

Try running that...

Regards

 

[Dsuperc]

LINKED TABLES

Ok guys, I found it.
Just to let others know.
Tools/Database Utilities/Linked Table Manager.

 

[namliam]

Linked table manager....

Regards

Tools/Database Utilities/Linked Table Manager.

If you dont know where something is, ASK....

Geezzzzzz

Regards

 

[pbuethe]

What if you don't have the Linked Table Manager installed? The IS Dept. did not give me the complete installation with all the wizards etc.

 

[Pat Hartman]

Then call your support desk and ask them to reinstall Access using a custom install. Make sure that you get ALL the wizards, help files, and samples. And point out that this should be the standard install for Access.

 

[namliam]

pbuethe or try the code i supplied above...

Regards