When retrieving LONG columns, MS ACCESS does not behave correctly to the correct return code in pcbValue. Therefore it is not possible to retrieve OLE objects from a table. The LongVarTrunc option can be used to achieve that the return code is built in another way than provided in the ODBC specification. The following return codes can be set:
Syntax:
LongVarTrunc = n
where n can assume one of the following values
LONG_MAX = -1 (for MS ACCESS)
cbValueMax = -2
cbValueMax+1 = -3
SQL_NO_TOTAL = -4 (default ODBC)