Memo field is manipulated through DAO

J

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
 
D

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)
 
Top