i cannot retrieve the data field from msaccess(datatype is memo) using asp but all other fileds using various data types are displaying
i change the memo datatype to text datatype its working fine.

but i want it to be in memo b'cause the contents are large

Anybody plz reply me quickly

Waiting...................

I think that memo datatype in MS Access is the same as TEXT datatype in MSSQL. So you need to move the field with memo datatype to the last position in your SELECT clause. Click the following link to review the details.

Missing Values from specific fields

thank you for your help

but since the memo field is not working,but when i change the memo field to text field(text capacity is max 255) its working.

so ok,plz waiting for a another solution, i am also try from another side

If you put the MEMO field at the last postion of your SELECT clause, it should be working.

Thankyou Sir

Its working fine............