Current recordset does not support updating...

[gorack]

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

My code is in VBSCRIPT

i create a connection
then

Set rs = CreateObject("ADODB.Recordset&quot
rs.Open "table", SourceConn, adOpenDynamic
rs.addnew

the addnew bring me the error above (3251)

 

[sidver]

add this to the open parameter
",adlockoptimistic"
i thing you forget this string
ie.
Set rs = CreateObject("ADODB.Recordset&quot
rs.Open "table", SourceConn, adOpenDynamic",adlockoptimistic