Link to database

[vinniencc1701]

hi guys

I have linked to an external daabase and am now trying to list all table names in this database. Des any one know how i can do this?

Thanks

[Swatty]

If your'e linked to it you can run through the tables

Dim dB As Database
   Dim mtbld As TableDefs
   Dim i  As Integer
   Dim msg As Strring
 
   Set dB = CurrentDb()
   Set mtbld = dB.TableDefs
   
   
   For i = 0 To mtbld.Count - 1
      If InStr(mtbld(i).Name, "Msys") = 0 And mtbld(i).Connect <> "" Then
         msg = mtbld(i).Name & vbcrlf
 
      End If
   Next
    
   msgbox msg
   Set mtbld = Nothing
   Set dB = Nothing

This will show you all linked tables

[vinniencc1701]

cheers swatty works a treat!!!