Recordset does not support updating Mastrubation chat

13-Sep-2016 07:02

By Mike Hillyer One of the most common sources of trouble for the beginning VB / My SQL developer seems to revolve around which cursor location to use.

Related to the cursor location problem is the choice of cursor type and lock type.

The exceptions (which arguably fit in either) are when people are writing VBA code to interact with a database.

Open str SQL, cn, ad Open Static, ad Lock Optimistic rs. In fact I have gone to other code sites for answers and seen some of the moderators from here arguing instead of providing answers.... VBA questions (even for Access) generally belong in the Office Development forum.

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

Recordset Dim db As Variant Dim str SQL As String Dim w Sheet Name As Variant db = "\SIMPLAN-SWATHI\Users\mgt\dbdata.accdb" //Network DB path cn.I use a variable just to make it easier to change if i want to use this sub somewhere else.