Programmatically how can you tell a table is linked?

[Guest]

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

 

[Guest]

dim mytbl as TableDefs
dim blnIsLinked As Boolean

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

 

[Granny Spitz via AccessMonster.com]

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

If (Len(mytbl.Connect) > 0) Then
' It's linked.
End If

 

[Guest]

Thank you!

If (Len(mytbl.Connect) > 0) Then
' It's linked.
End If

 

[Guest]

Thank you!

dim mytbl as TableDefs
dim blnIsLinked As Boolean

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

 

[Granny Spitz via AccessMonster.com]

Thank you!

You're welcome, Sarah. Good luck with your project.