asp rich text access error

[sagey]

i have a rich text box on a form, that is submitted to an access db.
when i type text the insert works fine. when i copy and paste emails from my
lotus notes client. it either throws various ado errors or it throws the following

Provider (0x8000FFFF)
Catastrophic failure


which requires a restart of my dev box.

if however i copy and paste from lotus into notepad and then copy and paste that into my rich textbox the insert works fine. my assumption is that there are characters that access (or ado) cannot handle which f**ks this up.

this is really beginning to get on my t*ts. so any help would be much appreciated.

[RhythmAddict]

Sounds like it is bad characters killing access...Provide us with code, and the exact text youre typing into the box that causes it to error out. In the mean time, I usually use a function like this to eliminate ugly characters...

Function RemQuotes(pString)
    if Not IsNull(pString) then 
        RemQuotes =  Replace(Replace(Replace(Replace(Replace(pString,";","-"),"'","''"),"&"," and "),"""",""),",","")  
    else RemQuotes = pString end if
End Function
 
Dim myString : myString =  "Apostrophe's mess it up"
Response.write myString & "<BR>"
myString = RemQuotes(myString)
Response.write myString & "<BR>"