O'Reilly logo

Access™ 2007 VBA Programmer's Reference by Armen Stein, Geoffrey Griffith, Rob Cooper, Teresa Hennig

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

D.3. DAO Field Types

The following table lists the constants in the DAO DataTypeEnum and their corresponding data types in the Access Table designer.

DAO DataTypeEnumConstant ValueAccess Field Type
dbAttachment101Attachment
dbBigInt16Cannot create in Access, but can be used by linked tables
dbBinary9Cannot create in Access designer but can be created in DAO
dbBoolean1Yes/No
dbByte2Number, Field Size=Byte
dbChar18Cannot create in Access, but can be used by linked tables
dbComplexByte102Number, Field Size=Byte
dbComplexDecimal108Cannot create in DAO but can create in Access designer
dbComplexDouble106Number, Field Size=Double
dbComplexGUID107Number, Field Size=Replication ID
dbComplexInteger103Number, Field Size=Integer
dbComplexLong104Number, Field Size=Long Integer
dbComplexSingle105Number, Field Size=Single
dbComplexText109Text
dbCurrency5Currency
dbDate8Date/Time
dbDecimal20Cannot create in DAO but can create in Access designer
dbDouble7Number, Field Size=Double
dbFloat21Cannot create in Access, but can be used by linked tables
dbGUID15Number, Field Size=Replication ID
dbInteger3Number, Field Size=Integer
dbLong4Number, Field Size=Long Integer
dbLongBinary11Number, Field Size=OLE Object
dbMemo12Memo
dbNumeric19Cannot create in Access, but can be used by linked tables
dbSingle6Number, Field Size=Single
dbText10Text
dbTime22Cannot create in Access, but can be used by linked tables
dbTimeStamp23Cannot create in Access, but can be used by linked tables
dbVarBinary17Cannot create in Access, but can be used by ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required