Hi,

I am using ASP to connect to an access database. One of the fields in the database has been set to the memo datatype. When I construct a recordset to display certain entries on my website the entries in the memo datatype field are all truncated to 255 characters.

The SQL statement used to create the record set is as follows:

strSQL = "SELECT ENTRY_SUBJECT, AUTHOR, DATE_, TIME_, ENTRY_CONTENT"
strSQL = strSQL & " FROM OL_TABLE WHERE (Shift = '" & shift & "')"
strSQL = strSQL & " AND (DATE_ < #" & toDate & "#) AND (DATE_ > #" & backToDate & "#)"

The ENTRY_CONTENT field is the one that is being truncated.

Is there something that I have to do when opening the recordset to preserve the access datatype memo?

Any ideas?

James