Tango cam sex - Error 3251 current recordset does not support updating

I'm trying to find out if any records exist, if they do, edit the record. but i'm getting the error message: Run-time error '3251': Current Recordset does not support updating. ", Buttons:=vb Yes No, Title:="e Prisoft") If Edit Tar = vb Yes Then prd Dsc("hs_cod") = Trim(cbo Tariff No2.value) prd Dsc. Execute("UPDATE hs_log SET hs_cod = '" Trim(cbo Tariff No2.value) "' WHERE prd_dsc = '" LCase(Trim(txt Desc.value)) "'") End If Msg Box "Edit" Else 'else insert new record prd Dsc.

This may be a limitation of the provider, or of the selected locktype. Add New prd Dsc("prd_dsc") = LCase(Trim(txt Desc.value)) prd Dsc("hs_cod") = Trim(cbo Tariff No2.value) prd Dsc. Close Set conn = Nothing End Sub Set prd Dsc = New ADODB.

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

error 3251 current recordset does not support updating-67

Close Set cn = Nothing ****************************************** We both use access2007 and excel 2010 I use excel 2010 and my user excel 2007.

In my following code following error is displayed at line 4, whenever I execute the query str SQL. Anonymous If you create a recordset using connection.execute or command.execute, you will get a forward-only, read-only recordset.

We're a friendly computing community, bustling with knowledgeable members to help solve your tech questions.

Please join our friendly community by clicking the button below - it only takes a few seconds and is totally free.

I also see no DIM statement for either cn or rs (maybe at the module level, or global?

BOF The first thing I notice is that the code from line 40 through 53 is not inside a sub or function, and appears never to execute. Execute("SELECT hs_cod FROM hs_log where prd_dsc = '" LCase(txt Desc.value) "'") Set prd ID = conn. Range("B: C"), 2) 'If stor Tar Dsc Prd = "1" Then 'store tariff and description If Not (prd Dsc. EOF) Then 'There are no records if Beginning-Of-File and End-Of-File are both true.Execute("INSERT INTO hs_log (prd_dsc, hs_cod) VALUES '" LCase(Trim(txt Desc.value)) "','" Trim(cbo Tariff No2.value) "'") Msg Box "Insert" End If 'Else If stor Tar Dsc Prd = "2" Then 'store tariff and productid 'Else 'dont store tariff 'End If 'Error Handler: 'Err. I believe that the way you've declared it will result in it being a Variant rather than an ADODB. This might not be an issue but better to eliminate the possibility by declaring it explicitly.I didn't read the code carefully though, so may have missed them. Firstly you might take a shot at changing some of your coding habits. When you are accessing recordset fields it is important to identify the field with something other than 0, 1 and 2. Or are they supposed to be in the code where you have the "UPDATING STUFF HERE" type comment? You will always have to check back to see what they mean. When you are accessing recordset fields it is important to identify the field with something other than 0, 1 and 2. But if I directlyupdate the table at the current postion, then it works. Read-only and forward-only lock and cursor types are the also the default for recordset objects.

Tags: , ,