Type Indicators in a Microsoft Access Provider

This table shows how a Microsoft Access provider might map its data types to OLE DB data types.

Microsoft Access data type

OLE DB type indicator

BINARY (< 255 bytes)

DBTYPE_BYTES

BIT

DBTYPE_BOOL

BYTE

DBTYPE_UI1

COUNTER

DBTYPE_I4

CURRENCY

DBTYPE_CY

DATETIME

DBTYPE_DATE

DOUBLE

DBTYPE_R8

GUID

DBTYPE_GUID

LONG

DBTYPE_I4

LONGBINARY

DBTYPE_BYTES

LONGTEXT

DBTYPE_STR

SHORT

DBTYPE_I2

SINGLE

DBTYPE_R4

TEXT (< 255 bytes)

DBTYPE_STR