Memo field is manipulated through DAO

[Jim]

I have an Access 2000 database that I am using for a .asp
page on a web site. I am using a Memo field but it will
only let me have 65,000 characters. The help file tells
me: "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.)"

How do you manipulate a Memo field through DAO to get the
field to accept unlimited characters?

Thanks

 

[david epsom dot com dot au]

ApendChunk and GetChunk.

ADO has similar methods.

It is also possible to write the chunks into
small memo fields and then use them to update a
large memo field (!)

If you can get rid of the CR LF (NULL? EOF?)
characters, you may also be able to write SQL
to import directly from file into a memo field.

(david)