Current recordset does not support updating locktype


Clearly the FAQs don't always contain the answers, but if they do then they are generally better than a reply to a thread - because those of us who write FAQ articles typically spend about 50 times as long writing them (including checking documentation, testing code, searching previous threads for alternate solutions/caveats, etc). take it easy on the people asking questions geek man.

Those are the places you should be looking - especially the FAQs, as they are a fairly short and simple list of bullet points (with shortcuts to each section, so you can quickly drill-down to the part that is likely to answer your question). your 28,365 posts Jul 02 are probably mostly this kind of arguing due to you being the biggest know it all of this subject...

Best of Luck Joydeep Also You are mixing approaches in the way you instanciate and use your database objects. Connection then you should NOT set it to nothing inside your code.

and you did not define the record in the open recordset syntax. Do it as below-"select * from table1",conn,adopenstatic,adlockoptimistic I think this is work for your problem.

Create parameters End With Set rs Data as New ADODB. Open cmd Proc,, ad Open Static,ad Lock Batch Optimistic '...

On the Visual Basic side, I recommend you have service pack 5 installed for VB, which you can download here. In ADO, when we talk about cursors, we are essentially talking about a set of rows.

Additionally, the latest version of MDAC (Microsoft Data Access Components) should be installed, and can be found here (currently 2.7 SP1). When you execute a query that returns rows of data, such as .

I am getting a '3251' error "Current Recordset does not support updating.

Whether you like it or not, moving your thread to the correct place (and explaining why) is helping you to use the forums better, to increase your chances of getting help. if not then feel free to ask questions, as that is what I come here for (and what the vast majority of my posts are about).

It worked fine in Access, but when I switched to SQL Server it stopped working.

Public Sub cmdbtt_Add_Click() Dim con As New ADODB.

I keep getting this error when I try to update Current Recordset does not support updating.

This may be a limitation of the provider, or of the selected locktype.

You must have an account to comment. Please register or login here!