I use a "INSERT INTO" instruction to add new record, the value of one field is HTML code that having quotation mark and comma ,
i get this error when submit:

²»ÄܲÙ×÷£¬ÏµÍ³±¨ÈçÏ´íÎó£ º
Microsoft JET Database Engine ´íÎó '80040e14'
Óï·¨´íÎó (²Ù×÷·û¶ªÊ§) ÔÚ²éѯ±í´ïʽ ''openBrWindow('Store_detail.asp?InfoID=1','detail ','scrollbars=auto' ÖС£

it seen that the html code has damaged the SQL statement.
How to solve that problem if i must use the html data??

I solved this problem by inserting the HTML code while retrieving the data instead of storing it in the DB.

SELECT zip, dname, address + '<br>' + city, phone
FROM Dealers
GO

HtH



Sandra MacGregor