hello there,
Its showing that Run-time error '3251': Current Recordset does not support updating. This may be a limitation of the provider, or the selected locktype. Any help regarding this would be great.
Thanks in advance for any replies.
Bmora96

could you show us your code?

hi,

I think you used the adLockReadOnly Lock type. So it displays error. If you use the adLockReadOnly Lock type then the records are said to be readonly record so it wont allow u to change the values in the record. When you like to manipulation(insert,update,delete) use adLockBatchOptimistic or adLockOptimistic .

Shailaja:)
:) have a good day.:)

Hi there ,

try this

dim rs as new adodb.recordset
set rs = new adodb.recordset

rs.locktype = pessistimistic ' allow you to change recors

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.