trouble with submitting html in sql queries

I have been having trouble with submitting html code to my access database. What happends is that when I try to write to the database it ends up corrupting it. the thing is though that it doesnt always corrupt it. (by the way the error is "The search key was not found in any record.")

I was just wondering if anyone else has come up against this problem before and how they fixed it. Also if anyone has any suggestions on how i can successfully submit html code to the DB without it bringing up errors all the time.

Cheers

if u r using SQL statment to insert data in a database then u get errors..

try this

rs.open "tablename",2,2
rs.addnew
aa = request.form("htmldata")
rs.update

hope u solve it now.

Sorry could you explain this a little better, where does aa come from?