Determining the source of linked tables...

[robertlevine]

I've been given the menial task of determining the UID and PASSWORD used by each of the linked tables within a few dozen Microsoft 97 databases I support.

Is there a way, other than opening each table in design mode and looking at the properties, to see the linked table properties? Perhaps a easy to view list?

Thanks and regards,

 

[Travis]

It's been awhile since I've used A97.

But I seem to recall that there is a Documentor function in Access under the tools menu.

 

[robertlevine]

Thanks, but the documentor function isn't quite what I'm looking for. The report format that it provides is static, and I cannot easily pull the connectionstring from the report.

 

[MattS]

Hmm, I'm currently using A2K, but I think the following code will work in 97:

Public Sub sShowConnections()
Dim tdefLinked As TableDef

    For Each tdefLinked In CurrentDb.TableDefs
        If tdefLinked.Connect <> "" Then Debug.Print tdefLinked.Connect
    Next

End Sub

Just go into the debug (immediate) window and run the sub.

Hope it works!

Matt.

 

[robertlevine]

Close! How would I add the table name along with the connection string so that I know which table is connected via each specific connection string!

If you can do that, you're the greatest!

 

[MattS]

Just add the name property:

Public Sub sShowConnections()
Dim tdefLinked As TableDef

    For Each tdefLinked In CurrentDb.TableDefs
        If tdefLinked.Connect <> "" Then Debug.Print tdefLinked.Name & " \ " & tdefLinked.Connect
    Next

End Sub

Glad I could help!

 

[robertlevine]

both ways work like a charm. thanks guys. made my life THAT much easier today.