-
Access memo field 64k limit...
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
-
Re: Access memo field 64k limit...
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
-
Re: Access memo field 64k limit...
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)
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Development Centers
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center
|