memo field problem

[gustavopalminha]

Hello all.



I'm writing because i don't know how to handle on a programmatic way a memo field.

I have a mdb file with a few tables with columns but and one of them is a MEMO type column. Its description refers that it contains "a binary representation of a zip file containing an image". This should mean that the contents of this column is binary data and I would like to read it and to save this zip file to my hdd drive.

Does any one have and idea on how to do it? Using DAO, VB Net or other language?

Thanks in advance.

[June7]

I have never heard of this. How did the data originally get stored in the field?

Maybe these offer clue to solution
http://support.microsoft.com/kb/225925

[gustavopalminha]

Hi.

Well, I think that the software developer used the appendChunk method from ADO.

I believe that the proper way to get this would be something like using the getchunk method to extract the data, but i'm just guessing.

I'm trying to do that, because i've neved used this method before.

Thanks.

[June7]

Beyond my experience. Hope the referenced links help.

[orange]

I haven't seen that done with a memo field. I have seen examples of storing images in OLE fields (I think it was acc2000 or 2003) . Here's a reference from M$oft.
http://support.microsoft.com/kb/103257