hai all,
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/nsc/tracking/signup.asp, line 17
the code is:
<%
set con=server.CreateObject("ADODB.connection")
set rs=server.CreateObject("ADODB.recordset")
con.open "DRIVER={Microsoft Access Driver (*.mdb)};DBQ="&Server.MapPath("shipmentLogin.mdb")
'con.open "DSN=LoginDSN"
response.write server.mappath("shipmentLogin.mdb")
16------------sql="insert into tblLogin values('" & Request.Form("UserID") & "', '" & Request.Form("Client") & "','" & Request.Form ("Name") & "','" & Request.Form("Password")& "')"
17---------rs.Open sql,con,1,3
18-------Response.Write "<B> <font color=blue size=4>Successfully Created</B></font> "
'rs.Close
set rs=nothing
con.Close
set con=nothing
%>
this code worked in my local system(http;//localhost/). that fine..i can uplode this into my website ....whenever i entered data that error shows..
i gave all permissions to that database file...
pls help me........