Accented Characters with ASP.Net and Access DB

[davetwooh]

Pretty simple thing here. . . i've got an html page with a bunch of fields on it. WHen i submit it, i just want to save the fields to an access database. Everything works fine except if you have Accented characters for example José, when it saves to Access, it drops the e, so im left with Jos. Im opengin the access db with the OLEDB Jet driver, and issuing an Insert statement.

Im stumped, never ran into this before.

Any ideas would be much appreciated!

Dave in CT

 

[davetwooh]

Actually, the problem seems to be in the transfer of data between the HTML form and the page that i POST to, when i post the data my ACTION page reads the text boxes on the HTML page using request.form(FieldName), it's at this point that the data already has missing accented characters. Is there some setting on the IIS server, or the web page that i have to set in order for it to pass me the accented characters as well??? Im stumped

Dave