Microsoft JET Database Engine error '80040e14' Syntax error in INSERT INTO statement. I have tired everything and don't know whats wrong. Here is my code. <% Dim strJT, strLocation, strJobT, strDesc, strRequirements, strContact, strContDetails, data_source, con, sql_insert Function ChkString(string) If string = "" Then string = " " ChkString = Replace(string, "'", "''") End Function strJT = ChkString(Request.Form("JobTitle")) strLocation = ChkString(Request.Form("JobLocation")) strJobT = ChkString(Request.Form("JobType")) strDesc = ChkString(Request.Form("JobDescription")) strRequirements = ChkString(Request.Form("JobRequirements")) strContact = ChkString(Request.Form("ContactName")) strContDetails = ChkString(Request.Form("ContactDetails")) data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _ Server.MapPath("db1.mdb") sql_insert = "insert into employmentnotice (JobTitle, JobLocation, JobType, JobDescription, JobRequirements, ContactName, ContactDetails) & _ values ('" & strJT & "', '" & strLocation & "', '" & strJobT & "', '" & strDesc & "','" & strRequirements & "', '" & strContact & "', '" & strDetails & "')" Set con = Server.CreateObject("ADODB.Connection") con.Open data_source con.Execute sql_insert ' Done. Close the connection con.Close Set con = Nothing %> ---------------------- Maybe permission issues with IIS v6?

You have a double quote and a single quote after values( Get rid of the single quote - you don't need it there as there is nothing to match it with. Stuart