DataTypeEnum Enumeration

  • Article
Access Developer Reference

Specifies the operational data type of an object.

Name Value Description
dbAttachment 101 Attachment data
dbBigInt 16 Big Integer data
dbBinary 9 Binary data
dbBoolean 1 Boolean (True/False) data
dbByte 2 Byte (8-bit) data
dbChar 18 Text data (fixed width)
dbComplexByte 102 Multi-valued byte data
dbComplexDecimal 108 Multi-value decimal data
dbComplexDouble 106 Multi-value double-precision floating-point data
dbComplexGUID 107 Multi-value GUID data
dbComplexInteger 103 Multi-value integer data
dbComplexLong 104 Multi-value long integer data
dbComplexSingle 105 Multi-value single-precision floating-point data
dbComplexText 109 Multi-value Text data (variable width)
dbCurrency 5 Currency data
dbDate 8 Date value data
dbDecimal 20 Decimal data (ODBCDirect only)
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
dbDouble 7 Double-precision floating-point data
dbFloat 21 Floating-point data (ODBCDirect only)
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
dbGUID 15 GUID data
dbInteger 3 Integer data
dbLong 4 Long Integer data
dbLongBinary 11 Binary data (bitmap)
dbMemo 12 Memo data (extended text)
dbNumeric 19 Numeric data (ODBCDirect only)
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
dbSingle 6 Single-precision floating-point data
dbText 10 Text data (variable width)
dbTime 22 Data in time format (ODBCDirect only)
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
dbTimeStamp 23 Data in time and date format (ODBCDirect only)
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
dbVarBinary 17 Variable Binary data (ODBCDirect only)
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.
Bb242635.vs_note(en-us,office.12).gif  Note
ODBCDirect workspaces are not supported in Microsoft Office Access 2007. Use ADO if you want to access external data sources without using the Microsoft Access database engine.