Store byte arrays in Access tables

  • Thread starter Thread starter Cristina Lopez
  • Start date Start date
C

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
 
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
 
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)
 
Back
Top