Linked xls (datasource) moved - get old path name

[jojones]

Hi

I have a database which has several linked tables, some to other dbs and some to excel workbooks. Some of the tables will no longer open because the source workbooks have been moved or deleted. The error that I get is that the Microsoft Jet database engine could not find the object 'GL_Postings'. In this case GL_Postings is the name of a worksheet within a workbook.

I need to get the name of the workbook, and also the path if possible. I cannot get into the design view of the table.

I have tried:

Sub GetPath()
MsgBox CurrentDb.TableDefs("tblAccruedIncomeAdjustments&quot.SourceTableName
End Sub

but it just returns the same 'GL_Postings'

Please help me.
THANKS LOADS!
Jo

 

[jojones]

I have just tried

Sub IAmGoingMad()
MsgBox CurrentDb.TableDefs("tblAccruedIncomeAdjustments&quot.Connect
End Sub

and it has returned the path of the file. Sorry if I distracted you from something important.

 

[jojones]

ACTUALLY.... If anyone can give me some code which captures the path & file name as a string I can use that would be great.

Ideally I could use some code that goes through ALL tables in my db and returns the path & file names.

thanks thanks thanks