hi
i am trying to connecting to my database on Microsoft access, i do a insert query and i recive an error this is my syntak:
Quote:
<%
Dim conn, SQLstr
set conn= server.CreateObject("ADODB.connection")
conn.ConnectionString="Provider=Microsoft.Jet.OLED B.4.0;" & "Data Source=" & Server.MaPpath("/")& "../login.mdb;"
conn.open
SQLstr="INSERT INTO tblCreateUse(f_name)"
SQLstr= SQLstr & " VALUES (SQLstr= SQLstr & Request("f_name") & "’) "
conn.Execute SQLstr
conn.Close
%>
|
and the message i recive is here:
Quote:
Error Type:
Microsoft JET Database Engine (0×80040E14)
INSERT INTO. he clame the mistake in this line
/regsup1.asp, line 6
please help me it in an emergency
i am at work, and i neet to solve this problem
thanks
nash31
|