Please help me to sove this problem.

I want to use the INSERT INTO sql statement in MS ACCESS and ASP and and used the following query

set conn=Server.CreateObject("ADODB.Connection")
conn.Provider="Microsoft.Jet.OLEDB.4.0"
conn.Open(Server.Mappath("Travel.mdb"))
sql="INSERT INTO Tmp_Hotel (Mem_id,Hotel_id,credit_num)"
sql=sql & " VALUES "
sql=sql & "('" & nmemid & "',"
sql=sql & "" & nhotelid & ","
sql=sql & "" & ncrednum & ")"

on error resume next
conn.Execute sql,recaffected

But, i have the abouve error and please help me how to solve.

This may help
http://support.microsoft.com/default...NoWebContent=1