Programmatically how can you tell a table is linked?

S

Sarah

Does anyone know how to tell if a table is linked? Right now this what I have.

dim mytbl as TableDefs
For Each mytbl In dbs.TableDefs
If mytbl.Name = "tblSeq" Then
SDPData = True
End If
Next mytbl

How can I tell that the table tblSeq is a linked table?

Thank you,

Sarah
 
K

Klatuu

dim mytbl as TableDefs
dim blnIsLinked As Boolean

For Each mytbl In dbs.TableDefs
blnIsLinked = Len(mytbl.Connect) <> 0
Next mytbl
 
S

Sarah

Thank you!

Klatuu said:
dim mytbl as TableDefs
dim blnIsLinked As Boolean

For Each mytbl In dbs.TableDefs
blnIsLinked = Len(mytbl.Connect) <> 0
Next mytbl
Click to expand...
 
Top