Display path of a linked table

[PhillipsAndrew]

Does anyone know how to display the path of a linked table?

I have a split database, and whenever I want to test new things I change the links to local data... I know that it's an accident waiting to happen that I will forget to link back to the live data...

What I want to do is display the path in a sort of 'About' window in my front end.. That way, I always know that my front end is linking to live data..

Thanks all,

 

[namliam]

have you tried Mile's Idea?

Regards

The Mailman

 

[PhillipsAndrew]

I will continue to search the Forum, but have found nothing yet....

I should add that I know about Linked Table Manager etc... However, I want to be able to get the path as a string and display it on forms etc..

 

[namliam]

Because i am in a good mood today:

currentdb.tabledefs("YourTable").connect

Regards

The Mailman

 

[PhillipsAndrew]

Thanks,

That looks like what I wanted...