hi dear, can anyone tell me what is the problem with my code? i am unable to insert record into my database. im using access 2003. whenever i insert record it says "No update permissions!" and i havent put any kind of password or restriction over it :(
it display record my dont insert new records
<html>
<body><%
set conn=Server.CreateObject("ADODB.Connection")
conn.Open "db1"
sql="INSERT INTO name (fname,lname,"
sql=sql & "fname,lname)"
sql=sql & " VALUES "
sql=sql & "('" & Request.Form("fname") & "',"
sql=sql & "'" & Request.Form("lname") & "',"
on error resume next
conn.Execute sql,recaffected
if err<>0 then
Response.Write("No update permissions!")
else
Response.Write("<h3>" & recaffected & " record added</h3>")
end if
conn.close
%>
</body>
</html>