Database filename and path of a Linked Table 1

[shannonp]

Looking for a quick and simple VB solution to retrieve the filepath and filename (i.e. "c:\backend\mydb4.mdb") of any given 'linked table'.


Shann

 

[RoyVidar]

Here's what a quick web search revealed:

http://support.microsoft.com/kb/210062

I e, examine the .connect property of the tabledef object. It will return a zero length string, I think, if it isn't a linked table.

Roy-Vidar

 

[shannonp]

Thanks Roy-Vidar! This is exactly what I was looking for!!


Shann