Displaying the location of a linked database table in Access 2003

I have an Access system that uses linked tables to store the data separately from the system design & code. I am trying to implement a text box to display the location of the database that the system is currently linked to to make sure I am using the right data.

I am using the following expression which works fine in Access 2000, but not in 2003. Can someone please help me to update this to work in 2003?

=currentdb.tabledefs("table1").[Connect]

Thanks
Geoff

re: Displaying the location of a linked database table in Access 2003

Hi,
Can you try withot the brackets of Connect?

If it does'nt work you can try using only the index of the respective table instaed the name!

And sometimes it's better to set the database to a variable and then use the variable with the statement!

But it have to work!

TableDefs(intloop).Connect