Can anyone help? - I have my code for updating my database using insert statement - can anyone check it as its bringing up a syntax error and I can't figure it out.


data_source = "Provider=Microsoft.Jet.OLEDB.4.0; Data Source=" & _
Server.MapPath("vacancies.mdb")
sql_insert = "INSERT INTO job (position,jobdescription,salary,startdate,contact) " & _
VALUES ('" & position & "', '" & jobdescription & "', '" & salary & "', '" & startdate & "', '" & contact & "')"