This problem must have been solved 100 times, but I&#039m still stumped.<BR>My JScript ASP script has problems storing data into ACCESS<BR>when there are quotes in the data (ex. bob&#039s house ).<BR>I know that for SQL you can just replace a single quote with a pair of them, but my problem appears to be with JScript, BEFORE the SQL is executed.<BR>Problem is that using ADO with Access, your text fields need to be single quoted.<BR><BR>conn.Execute( "INSERT INTO mytable (fld1) VALUES (&#039" + val1 +"&#039)" ); <BR><BR>I can&#039t yet figure out what to do if val1 = "bob&#039s house"<BR><BR>can someone please point me to a Jscript solution???<BR>thanks in advance,<BR>-- david