Does anybody have a list of characters that are invalid in Access97? I'm
taking user input from a webform, and it keeps breaking and throwing an odbc
error. So far, I'm replacing the single quote (') and hyphen (-) .... maybe
somebody has a custom function they've coded up that they'd be willing to
send the list? From asp, I'm doing a:
str = Request.Form("blah")
str = replace(str, "'", "''")
str = replace(str, "-", " ")
objRS("blah") = str
what I'd like to do is:
objRS = myFunction(Request.Form("blah")
And have all the parsing done in myFunction. That way, I could also add in
some web-specific stuff, like getting rid of all the html tags.
-- Meredith Shaebanyan