error in insert query

[salman.pirani]

ear sir

db is corect query is corect i dnt knw whr is the error

out put
G:\wwwroot2\hr\tform\admin\webdata\course.mdbError code -2147467259INSERT INTO course (pt,course_owner,training_cordinator) VALUES ('sss','w','w')

<%
set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.MapPath("webdata/course.mdb"))
response.Write(Server.MapPath("webdata/course.mdb"))
sql="INSERT INTO course (pt,course_owner,"
sql=sql & "training_cordinator)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("pt") & "',"
sql=sql & "'" & Request.Form("course_owner") & "',"
sql=sql & "'" & Request.Form("training_coo") & "')"


    on error resume next
conn.Execute sql,recaffected
if err<>0 then
    Response.Write("Error code " & err)
else
   Response.Write("<h3> Programme Title has been created</h3>")
end if
response.Write(sql)

  conn.close
%>

[gk53]

I guess you have access database file and file already open exclusively by another user... so it is locked for any updates by another connection...

[BLarche]

You can clean up your SQL too:

strSQL = "INSERT INTO Course (pt, course_owner, training_coordinator) VALUES (" & _
	"'" & Request.Form("pt") & "'," & _
	"'" & Request.Form("course_owner") & "'," & _
	"'" & Request.Form("training_coo") & "'" & _
	")"