Member Avatar for bmora96

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

  • 4 Contributors
  • 3 Replies
  • 75 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by hawisme000
Member Avatar for cometburn

could you show us your code?

Member Avatar for manoshailu

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.:)

Member Avatar for hawisme000

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.