Linked Table

  • Thread starter Thread starter יעקב
  • Start date Start date
×

יעקב

Hi,
I have a mdb file with few Linked table, Linked to a nother mdb file,
How can I found which mdb file they Linked to,

Thank you very much,
Yakov
 
Hi,
I have a mdb file with few Linked table, Linked to a nother mdb file,
How can I found which mdb file they Linked to,

Thank you very much,
Yakov
Click to expand...

either use the linked table manager or do something like this...

dim tdf as dao.tabledef
for each tdf in currentdb
if len(tdf.connect)>0 then
debug.print tdf.name, tdf.connect
end if
next tdf
 
Piet,
you are missing a level. It should be:

dim tdf as dao.tabledef
Dim tdfs as DAO.TableDefs

Set tdfs = CurrentDb.TableDefs
for each tdf in tdfs
if len(tdf.connect)>0 then
debug.print tdf.name, tdf.connect
end if
Set tdfs = Nothing
next tdf
 
Piet,
you are missing a level.  It should be:

dim tdf as dao.tabledef
Dim tdfs as DAO.TableDefs

    Set tdfs = CurrentDb.TableDefs
        for each tdf in tdfs
        if len(tdf.connect)>0 then
           debug.print tdf.name, tdf.connect
        end if
    Set tdfs = Nothing
next tdf
Click to expand...

that's what happens when you don't actually use Access to write the
stuff... my mistake... thanks Dave!
 
Back
Top