Can't See entire Path of linked table

[Amileaux]

The person that has this database is out of town and, of course, his queries aren't working. I've narrowed the problem down to a linked table that access can't find. But the link manager doesn't let me see the entire path and I can't figure out where it thinks this table is. Any simple way to figure this out? I've tried to copy and paste into word - but that is not working. Any help would be greatly appreciated! Thank you. Marie

 

[dcx693]

If you go into table design view for that table (click Yes when warned that you can't modify linked tables), go to the View menu and choose Properties. The description line should have a path to the table location.

 

[Amileaux]

It didn't work. I clicked the table to open in design view, asked me if I wanted to open in read only - clicked yes and then it said "The mircorsoft jet database engine cannot find the input table or query "Weekly...." Make sure etc" and then doesn't open it. Any other thoughts? Marie

 

[dcx693]

Eek. Sorry, can't think of anything else easy. Do you have a backup copy of the database anywhere?

 

[Amileaux]

Yes he has one - but the curious thing is that in the backup the table is not linked! Oh well. Thanks for trying! Marie

 

[pdx_man]

Try working with this:

Public Sub TableDefX()
Dim tdfLoop As TableDef
Dim dbs as Database

   Set dbs = CurrentDb

' Enumerate TableDefs collection for tables linked
    For Each tdfLoop In dbs.TableDefs
        Debug.Print tdfLoop.Name, tdfLoop.Connect
    Next tdfLoop

End Sub

 

[Amileaux]

You are good!!! Thank you. That worked! Thanks again. Marie

 

[pdx_man]

Ya sure ... Ya betcha

 

[Pat Hartman]

You can also see the complete path by opening the MSysObjects table and looking at the connect property.

 

[pdx_man]

Just an FYI

I see it under the Database property in A97.

 

[Pat Hartman]

Ok so it's the database property I was looking at a linked ODBC table.