Hello everybody

I am using MS Access and ASP for a small website. In the database I have a few field which are of the type "Memo".

When I read a field from a RecordSet, I can only do it once. The second time I read the field it is empty (""). Thus, I can only read the field once.

The solution is to store the value in a variable, and then use this variable. However, I am more curious of why this problem occurs and how to fix it at RecordSet/Connection "level".

Any suggestions?

Found the answer, for anyone with the same problem, check out:

http://www.aspfaq.com/show.asp?id=2188
and
http://support.microsoft.com/?kbid=200124

What version of IIS and MDAC are you running on your web server??