Hi, below is my coding and when I key in single quote in the text field / text area, it gives below error message, please help resolve it!!

Error Type:
Microsoft Access Database Engine (0x80040E14)
Syntax error in string in query expression '''')'.

Coding:
<%
dbsharingDate = Request.Form("sharingDate")
dbsharingEmail = Request.Form("sharingEmail")
dbsharingSubject = Request.Form("sharingSubject")
dbsharingContent = Request.Form("sharingContent")

Response.Buffer = True

If Request.Form.Count > 0 Then

set conn=Server.CreateObject("ADODB.Connection")
conn.provider="Microsoft.ACE.OLEDB.12.0"
conn.open(server.mappath("dbSCOFKE.accdb"))
set rs=Server.CreateObject("ADODB.Recordset")

msql = "insert into tbSharing (sharingDate, sharingEmail, sharingSubject, sharingContent) values ('"&dbsharingDate&"','"&dbsharingEmail&"','"&dbsha ringSubject&"','"&dbsharingContent&"')"
conn.Execute(msql)


conn.Close
Set conn = Nothing

Response.Redirect "SharingInput.asp"

End If
%>