skip to content »

desd.sytna-hata.ru

Recordset does not support updating

recordset does not support updating-80

Active Connection = "Provider = SQLOLEDB; Data Source = ..." my Cmd. This may be a limitation of the provider, or of the selected locktype. Parameters("@my Batch Hi, your problem is a typical error: replace Set rs Donations = my Cmd. Cheers corvanderlinden and Bahnass: Sorry, your solutions do not work; I still get the same error message: Current Recordset does not support updating. corvanderlinden: This is my sp: REATE PROCEDURE sp_Receipts_By Batch No @my Batch No int AS select a.

This may be a limitation of the Provider, or of the select Locktype). The following is a chopped down version of my code... Open "Driver=; Dbq=c:\Website Projects\Exit Cash Flow\log M.mdb;" str SQL = "Select * From Main Where Username = '" & str Query & "' and Domain = '" & str Domain & "'" Set rs Main = cn. Close Set rs Main = Nothing ======= End of Code ========= .mdb;" str SQL = "Select * From Main Where Username = '" & str Query & "' and Domain = '" & str Domain & "'" rs Main. Execute (str SQL) method returns a read-only recordset. Open str SQL, cn) and that took me a few minutes to figure out why I was getting a '3001' error... I have removed everything except the code dealing with the recordset... I use a variable just to make it easier to change if i want to use this sub somewhere else.var microsoft = microsoft || ; microsoft.support = microsoft.support || ; microsoft.support.content = (function(){ return { "click Tale Configuration": , "Internal Content Config": , "Mwf Configuration": , "Rps Sign In Info": , "Site Content Config": { "Link Farm Enabled": true, "One Site Service Uri": "https://uhf.microsoft.com//shell/xml/?Connection strmess = "SELECT * from tblinvoicelines WHERE invoice=" & new Invo Set red1 = cnp.

Connection strmess = "SELECT * from tblinvoicelines WHERE invoice=" & new Invo Set red1 = cnp.

Active Connection = "Provider = SQLOLEDB; Data Source = ..." my Cmd. Using the ADO Recordset Object, you can update a field, and the update method will submit the necessary update statement to the underlying database...

Parameters("@my Batch mmcmillen: using ADO, you issue a select, and generate the ADO Recordset object.

Open "Requests", cn, ad Open Keyset, ad Lock Optimistic, ad Cmd Table With rs .

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

This may be a limitation of the provider, or of the selected locktype." Here is the relevant part of the code: ********************************************** Dim cn As ADODB.