ASP and Access: Memo Fields

[YoelBenYossef]

Hi there,
I'm trying to use access to store data that I get in an ASP form. When I'm uploading to a field in my asp page to access, I use the commands:

rst.AddNew
rst("EventName")=request.form("txtEventName")
rst.update

It works perfectly if the field that I'm inserting into in access is anything but the Memo field. Does anyone know what command should be used to upload into a memo field?

Thanks
Eric

 

[Sheco]

Take a look at the AppendChunk and GetChunk methods.

 

[YoelBenYossef]

Thanks, it works great. I used it like this:

rst("OrderBarcodes").AppendChunk (request.form("txtBringBackBarcodes"))

Eric