DataTypeEnum Enumeration
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)
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.
|
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)
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.
|
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)
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.
|
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)
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.
|
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)
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.
|
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)
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.
|
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. |