How a Memo field is manipulated through DAO

  • Thread starter Thread starter Jim
  • Start date Start date
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
 
How do you manipulate a Memo field through DAO to get the
field to accept unlimited characters?
Click to expand...

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

HTH

Tim F
 
Tim Ferguson said:
.AppendChunk and .GetChunk methods, described in the Help files.
Click to expand...

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