Access memo field 64k limit...


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 3 of 3

Thread: Access memo field 64k limit...

Hybrid View

  1. #1
    Jeff Guest

    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

  2. #2
    Stephen Abel Guest

    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



  3. #3
    Paul Clement Guest

    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
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center