Can't connect Access Databse In My DomainServer

[usraju]

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.Crea teObject("ADODB .connection")
set rs=server.Creat eObject("ADODB. recordset")
con.open "DRIVER={Micros oft Access Driver (*.mdb)};DBQ="& Server.MapPath( "shipmentLogin. mdb")
'con.open "DSN=LoginD SN"
response.write server.mappath( "shipmentLogin. mdb")
16------------sql="insert into tblLogin values('" & Request.Form("U serID") & "', '" & Request.Form("C lient") & "','" & Request.Form ("Name") & "','" & Request.Form("P assword")& "')"
17---------rs.Open sql,con,1,3

18-------Response.Write "<B> <font color=blue size=4>Successf ully 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........

[sashi]

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.Crea teObject("ADODB .connection")
set rs=server.Creat eObject("ADODB. recordset")
con.open "DRIVER={Micros oft Access Driver (*.mdb)};DBQ="& Server.MapPath( "shipmentLogin. mdb")
'con.open "DSN=LoginD SN"
response.write server.mappath( "shipmentLogin. mdb")
16------------sql="insert into tblLogin values('" & Request.Form("U serID") & "', '" & Request.Form("C lient") & "','" & Request.Form ("Name") & "','" & Request.Form("P assword")& "')"
17---------rs.Open sql,con,1,3

18-------Response.Write "<B> <font color=blue size=4>Successf ully 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........

Hi there,

Are you sure r/w permission is given to the folder as well to the contents of the folder? Please check out these details. Good luck & Take care.