Check table definition : Table Properties « Access « VBA / Excel / Access / Word

1. VBA / Excel / Access / Word
2. Access
3. Table Properties

Check table definition

 
Sub exaCheckTableDefs()
    Dim db As Database
    Dim tbl As TableDef
    Set db = CurrentDb
    
    Debug.Print db.TableDefs.Count
    
    For Each tbl In db.TableDefs
        Debug.Print tbl.Name & vbTab & TypeName(tbl)
    Next
End Sub

 

Related examples in the same category