Attributes constants

[nkiefer]

I have the following code where I am enumerating the fileds in each table in my database:

' Enumerate TableDefs collection.
For Each tdfLoop In .TableDefs
Debug.Print tdfLoop.Name
For i = 0 To tdfLoop.Fields.Count - 1
Debug.Print tdfLoop.Fields(i).Attributes
Next i
Next tdfLoop

I am doing this to try and find which fields are autonumber. The code above lists the attributes as constants. Is there a file showing what each of these constants mean?

 

[vbajock]

dbByte: dataType = "Byte"
dbInteger: dataType = "Integer"
dbSingle: dataType = "Single"
dbDouble: dataType = "Double"
dbDate: dataType = "DateTime"
dbLongBinary: dataType = "OLE"
dbMemo: dataType = "Memo"
dbCurrency: dataType = "Currency"
dbLong: datatype="Long"