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:

<%

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:

Error Type:
Microsoft JET Database Engine (0x80040E14)
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

and the completed query looks like ??

Looks like a whacky string concat issue..

Since you are GOING to use string concat like that.. try it like..

SQLstr="INSERT INTO tblCreateUse (f_name)"
SQLstr= SQLstr & " VALUES ('" & Request("f_name") & "')"

Notice the single quotes on EITHER side of the string break doublequote..

Only problem is, this is bad form... try using Bind variables and SQL parameters instead.. It makes for a bit more code, but helps in protecting against SQL injection attacks.