excel vba - run time error 3251 current recordset does not support updating -


i using excel 2007. have updated record sets in past using code don't know why start getting "run time error 3251" on one. can me find out. please.

for information, fetching data access excel vba user form & doing updation & deletion per requirement.

 private sub update_finance_return_details_click()  dim rs adodb.recordset dim strsql string dim mydb string dim cn object  on error goto errorhandler    set cn = createobject("adodb.connection")    mydb = "x:\commercial\new automated invioce    tracker\commercial_invoice_tracker.accdb"    cn.cursorlocation = aduseserver    cn     .provider = "microsoft.ace.oledb.12.0"    'for *.accdb databases     .connectionstring = mydb     .open   end    set rs = new adodb.recordset   if rs.state <> adstateclosed rs.close    strsql = "select * [ct] [invoice_id] = " & me.id.value & ""    rs.cursorlocation = aduseserver   rs.open strsql, cn, adopenkeyset, adlockoptimistic    rs     if (me.clarification_rec_date_return.visible = true)         !fin_query_dt = me.clarification_rec_date_return.value     else         !fin_query_dt = null     end if      !fin_query = me.clarification_received_finance_return.value      if (me.clarification_resolve_date_return.visible = true)       !fin_query_resolve_dt =  me.clarification_resolve_date_return.value     else         !fin_query_resolve_dt = null     end if     !last_updated_by = environ("username")     !last_updated_on =     .update    .close  end   msgbox ("record updated successfully")  cleanexit:    cn.close    set rs = nothing    set cn = nothing    application.screenupdating = true     exit sub errorhandler:    msgbox err.description    resume cleanexit end sub

i know old thread had same issue sometime ago , felt worth updating resolved me.

similar situation yourself, working fine of sudden unable write access db. issue me down migration happend , users had read ntfs access access db. giving users write ntfs access resolved issue.


Comments

Post a Comment

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

i make custom datepicker directive custom template. but have no idea how start building it... how include date data directive? i appreciate guide or give me advice work on more precisely. it might you! follow below steps html code sample: <label>birth date</label> <input type="text" ng-model="birthdate" date-options="dateoptions" custom-datepicker/> <hr/> <pre>birthdate = {{birthdate}}</pre> <script type="text/ng-template" id="custom-datepicker.html"> <div class="enhanced-datepicker"> <div class="proxied-field-wrap"> <input type="text" ui-date-format="yy-mm-dd" ng-model="ngmodel" ui-date="dateoptions"/> </div> <label> <button class="btn" type="button"><i class="icon-calendar"></i>
Read more

javascript - jQuery date picker - Disable dates after the selection from the first date picker -

<!doctype html> <html lang="en"> <head> <meta charset="utf-8"> <title>jquery ui datepicker - default functionality</title> <link rel="stylesheet" href="//code.jquery.com/ui/1.11.4/themes/smoothness/jquery-ui.css"> <script src="//code.jquery.com/jquery-1.10.2.js"></script> <script src="//code.jquery.com/ui/1.11.4/jquery-ui.js"></script> <link rel="stylesheet" href="/resources/demos/style.css"> <script> $(function () { $("#datepicker1").datepicker(); }); </script> <script> $(function () { $("#datepicker2").datepicker(); }); </script> </head> <body> <p>date 1: <input type="text" id="datepicker1"></p> <p>date 2: <input type="t
Read more