How a 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

 

[Tim Ferguson]

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

.AppendChunk and .GetChunk methods, described in the Help files.

HTH

Tim F

 

[Dirk Goldgar]

.AppendChunk and .GetChunk methods, described in the Help files.

You don't have to go to those lengths, do you? I think, for example,
this would work to add a record with a million-byte memo field to a
table:

Dim rs As DAO.Recordset

Set rs = CurrentDb.OpenRecordset("tblMemos")
With rs
.AddNew
!MemoText = String(1000000, "X")
.Update
.Close
End With
Set rs = Nothing