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
[code=asp]
Set rscustomer = server.CreateOb ject("ADODB.Rec ordset")
rscustomer.Open sqlcustomer, MMToConn, 1, 3
'----
'----

'-----

if textnetworkid <> "" then

rscustomer.addn ew
rscustomer("cus tBadgeno") = textBadgeNo
rscustomer("cus tNetworkid") = textnetworkid
rscustomer("cus tWorktel") = textworktel

rscustomer.upda te
[/code]

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=Curren t+Recordset+doe s+not+support+u pdating

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

[jhardman]

Try
[code=asp]
Set rscustomer = server.CreateOb ject("ADODB.Rec ordset")
rscustomer.Open sqlcustomer, MMToConn, 2, 3
[/code]
This makes the cursor dynamic, I think Access needs a dynamic recordset in order to update. Let me know if it helps.

Jared