[AccessD] Linked Tables

Sat Apr 26 08:35:58 CDT 2003

On 26 Apr 2003 at 11:44, Mwp.Reid at queens-belfast.ac.uk wrote:

> Is it possible via code to determine the source of a linked table?
> 
> 

Look for the Connect string:

Dim tdfloop As TableDef
With CurrentDb
        For Each tdfloop In .TableDefs
            If Left$(tdfloop.Connect, 10) = ";DATABASE=" Then
                 Debug.Print Mid$(tdfloop.Connect, 11)
            End If
        Next tdfloop
End With

-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System 
Support.