Access no error is string length > 255

[jayapalchandran]

i have a database and in that a field name desc for storing lengthy text...
actually the text length in access is 255 but i tried to store more that 255
i didnt get any error at the same time the data didnt get stored...


str="insert into table1 values('sa',' text more that 255 letterx')
on error resume next
cons.Execute(str)

if err.Number<>0 then
response.write err.description
response.end
end if

the above code didnt show any error and it didnt get saved...

how to know whether an operation is successful in access or asp...

----

[parijaatp]

Remove the line "On error move next" from the code. This line causes the script to run even if the error is reported. Removing it should report the error on screen.

[jayapalchandran]

the datatype can hold a maximum of 255... so got to go for memo type...