Store byte arrays in Access tables

[Cristina Lopez]

Hi,
I'm trying to store long byte arrays in access. Memo is too small for me. I
think that Ole object will be fine, but my byte array isn't an ole object
and an error is throw when i try to add it.
How is the best way to do this?
Thanks

 

[Larry Linson]

Take a look at the GetChunk and AppendChunk methods of storing binary data
in an OLE Field -- for more information on using OLE Fields as Binary Large
Objects (BLOBs) search the Knowledge Base at http://support.microsoft.com
for Article 103257 (formerly Q103257).

For an example of using a Byte Array and OLE Field in this manner, download
my Access 2000 imaging example database from http://accdevel.tripod.com, and
look at the BLOB approach example.

Larry Linson
Microsoft Access MVP

 

[david epsom dot com dot au]

trying to store long byte arrays in access. Memo is too small for me.

Access won't let you type more than 64K into a field on a DataSheet,
but a memo field takes '1.2 GB' in A97/Jet 3, and (?) twice that with
Jet 4 (?)

I don't think you can put more into an OLE object field.

(david)