Ofline
77573 days on xHamster
84154M profile views
72201K subscribers
3824 comments left

Adodb recordset error 800a0cb3 current recordset does not support updating

Advantages to my approach Free Code To use the code, first open it here, then copy and past it into a new module. What I came up with was a central location to open my recordsets and for executing SQL commands using two function calls: Open My Recordset and Execute My Command. Although strictly speaking you don't have a prepared statement yet (only when you add obj Cmd. Execute()Hi, what you show looks about right actually..

His passion for Access has led him to helping a wide range of businesses in helping them establish a secure, stable and efficient environment with SQL Server. To be honest you don’t have to use the code block, but can also accomplish the same thing by just using the open statement, but I believed there was another way. Open "Select * from tbl Clients" End With Now imagine the above lines repeated over and over again in my code and you can imagine, it was a chore. Form("txt Description") & "'," & _ ' Assuming Description is a character data type " Entered By = '" & Request. Can you edit your SQL to include only the SLIHeader table, and make this work? You are using UPDATE, yet it appears that you are select columns like you would in a SELECT statement and you are expecting a recordset. Do you want to use an UPDATE statement (preferred) or a Select statement and then use ADODB Update method? Form("txt Stat") & "," & _ ' Assuming Stat is a numeric data type " Description = '" & Request. Execute str SQL Updated = "True" End If % Your SQL statement has three INNER JOINs, which are often not updatable, and looking at your criteria none of them may be necessary. Form("Entered By") & _ ' Assuming Entered By is a character data type Should be: " Entered By = '" & Request.

Form("txt SLINbr") & "," & _ ' Assuming SLINbr is a numeric data type " Stat = " & Request.

Please or register to post comments
If spammers comment on your content, only you can see and manage such comments Delete all

Adodb recordset error 800a0cb3 current recordset does not support updating introduction

Adodb recordset error 800a0cb3 current recordset does not support updating

Recent posts

14-Jul-2018 07:13
14-Jul-2018 12:34
14-Jul-2018 15:53