Reading memo fields in Access using asp and ado

Posted by Paul Farrow - Under: Software

as a reminder to myself really, in access 2000 there is now a memo field these can only be read once from the ado recordset in asp.  The second time the field will be null, ie if you do the following…

<%= myRS("linkname") %>

<%= myRS("linkname") %>

twice the second one doesnt return anything as it loses the field contents, I believe this is by design