Access memo field 64k limit...

[Jeff]

I'm writing an app that will store an html page's source into a field. I came
across a file that was larger than 64k and the field in Access of datatype
memo, choked. Basicly I learned there was a 64k limit on the Memo field...
How the heck do you store a text file larger than 64k in an Access database???

I'd appreciate any help.
Jeff

[Stephen Abel]

Here's a note from the Access 2000 help file that may help (if you can use
DAO in this program)!

"Memo - Up to 65,535 characters. (If the Memo field is manipulated through
DAO and only text and numbers [not binary data] will be stored in it, then
the size of the Memo field is limited by the size of the database.)"

If I have any better ideas I will let you know!!!

Good luck,
Steve

"Jeff" <jeff_d_gilbert@hotmail.com> wrote:
>
>I'm writing an app that will store an html page's source into a field. I
came
>across a file that was larger than 64k and the field in Access of datatype
>memo, choked. Basicly I learned there was a 64k limit on the Memo field...
>How the heck do you store a text file larger than 64k in an Access database???
>
>I'd appreciate any help.
>Jeff

[Paul Clement]

On 28 Jun 2001 00:59:31 -0700, "Jeff" <jeff_d_gilbert@hotmail.com> wrote:

¤
¤ I'm writing an app that will store an html page's source into a field. I came
¤ across a file that was larger than 64k and the field in Access of datatype
¤ memo, choked. Basicly I learned there was a 64k limit on the Memo field...
¤ How the heck do you store a text file larger than 64k in an Access database???
¤
¤ I'd appreciate any help.
¤ Jeff

This is not a limitation if you use the AppendChunk and GetChunk methods to store and retrieve your
data. See the documentation for more information.


Paul ~~~ pclement@ameritech.net
Microsoft MVP (Visual Basic)