RecordSet updation

[jestin]

hi friends we have a ASP intranet system and its backend is in MSAccess now we r upgrading its back end with Oracle 8i.

and i have a problem regarding the record set updation

the code is as follows

Set rscustomer = server.CreateObject("ADODB.Recordset")
rscustomer.Open sqlcustomer, MMToConn, 1, 3
'----
'----
 
'-----
 
if textnetworkid <> "" then
 
rscustomer.addnew
rscustomer("custBadgeno") = textBadgeNo
rscustomer("custNetworkid") = textnetworkid
rscustomer("custWorktel") = textworktel
 
rscustomer.update
 

the above code showing the error as follows***********************

Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.   
 

can anybody face this problem

if u have a solution plz forward the solution

[burtonfigg]

I had a look on Google:
http://www.google.com/search?q=Current+Recordset+does+not+support+updati ng

Does this one help:
http://www.vbforums.com/showthread.php?t=385832

[jhardman]

Try

Set rscustomer = server.CreateObject("ADODB.Recordset")
rscustomer.Open sqlcustomer, MMToConn, 2, 3
 

This makes the cursor dynamic, I think Access needs a dynamic recordset in order to update. Let me know if it helps.

Jared