Limitations on LONG_VARCHAR and LONG_BINARY

[maarten]

Hi,

I try to store a Long_binary (picture) into a ODBC source (through the
Microsoft Acces driver).

This seems oké for smaller "pictures", but bigger ones fail.

Does anybody what the limitations is for LONG_VARCHAR and LONG_BINARY
types are on ACCES ?


Rrgds,

 

[Pieter Wijnen]

Use the AppendChunk/GetChunk method of a recordset to store the data
the limit is 64K otherwise

HTH

Pieter

Hi,

I try to store a Long_binary (picture) into a ODBC source (through the
Microsoft Acces driver).

This seems oké for smaller "pictures", but bigger ones fail.

Does anybody what the limitations is for LONG_VARCHAR and LONG_BINARY
types are on ACCES ?


Rrgds,

--