在MS Access中，有没有一种方法可以用VBA来判断ODBC链接表是SQL视图还是表

Sub CheckODBCLinkedTable()
    Dim db As DAO.Database
    Dim tdf As DAO.TableDef
    
    Set db = CurrentDb
    
    For Each tdf In db.TableDefs
        If (tdf.Attributes And dbAttachedODBC) <> 0 Then
            Dim connectString As String
            Dim sourceTableName As String
            
            connectString = tdf.Connect
            sourceTableName = tdf.SourceTableName
            
            If InStr(1, connectString, "VIEW", vbTextCompare) > 0 Then
                Debug.Print sourceTableName & " is an ODBC linked SQL view."
            Else
                Debug.Print sourceTableName & " is an ODBC linked table."
            End If
        End If
    Next tdf
    
    Set tdf = Nothing
    Set db = Nothing
End Sub