MS Access Update Query to SharePoint List Locking up, no errors -

i combining multiple excel worksheets 1 sharepoint list our data in 1 place , modifiable multiple users @ once. append query worked without hitch.

now trying update 1 filed in list update query keeps locking ms access (not responding, 100% cpu usage). have terminate task manager.

i have let run as 10 minutes. switched 1 time use sub procedure below update through recordset. same issue.

i able update field manually 1 @ time via linked list in ms access. can update field via datasheet , dialog in sharepoint.

sharepoint 2010
ms access 2013

does have ideas?

option compare database option explicit  public sub updatedataplatedates()  on error goto err_trap     dim db dao.database: set db = currentdb()     dim rst dao.recordset     dim strsql string     dim integer: = 1     dim vdate variant     dim snum string      strsql = "select tml.[serial number], tml.[data plate date] [tool master list] tml (((tml.[data plate date]) null));"      set rst = db.openrecordset(strsql, dbopendynaset)     rst         if not (.bof , .eof)             .movelast: .movefirst             until .eof                 snum = ![serial number].value                 vdate = dlookup("[accept date]", "tool information", "[serial number]='" & snum & "'")                 debug.print i, snum, vdate                 if not (isnull(vdate) or isempty(vdate))                     vdate = cdate(vdate)                      .edit                          ![data plate date] = vdate  '//fails-locks right here without , error                     .update                 end if                  .movenext                  = + 1                  snum = vbnullstring                 vdate = null                 doevents             loop         end if         .close     end     set rst = nothing     set db = nothing exit_sub:     exit sub err_trap:     debug.print err.number, err.description     stop     resume   end sub 

is possible item trying update being edited user? have considered linking sharepoint table , performing update query instead?