title: Unable to execute update statement in ucanaccess
body: <p>I have a connection to a Microsoft Access database. Once I make the connection I'm trying to get everything from that table I'm accessing with the following query.</p>
  
  <pre><code>ResultSet rSet = stmt.executeQuery("Select * FROM DraftNightQuery")
  </code></pre>
  
  <p>As far as I am able to tell, that works fine. I then have a while loop that runs as long as rSet.nex().</p>
  
  <p>In my while loop I'm trying to run an update statement which looks like this:</p>
  
  <pre><code>connec.executeUpdate("UPDATE DraftNightQuery SET OwnerID='"+x+"' WHERE Last='"+split[0]+"' AND First='"+split[1]+ "' ");
  </code></pre>
  
  <p>and it's throwing this error:</p>
  
  <pre><code> net.ucanaccess.jdbc.UcanaccessSQLException: INSERT, UPDATE, DELETE or TRUNCATE not permitted for table or view
  </code></pre>
  
  <p>I'm assuming it has something to do with the update query itself, however that worked for ODBC, and from what I can tell on the UCanAccess website it should work for this as well.</p>
  
  <p>edit:</p>
  
  <p>SQL for query throwing <code>PUBLIC.NZ(DOUBLE)</code> error:</p>
  
  <pre><code>SELECT TotalStats.ID, Players.First, Players.Last, (Nz([TotalStats].[W]*25))-(Nz([TotalStats].[L]*5))+(Nz([TotalStats].[PG]*10))+(Nz([TotalStats].[QS]*10))+(Nz([TotalStats].[SV]*20))-(Nz([TotalStats].[BS]*5))+(Nz([TotalStats].[Holds]*15))+(Nz([TotalStats].[GF]*5))+(Nz([TotalStats].[Innings]*3))-(Nz([TotalStats].[PH]*1))-(Nz([TotalStats].[ER]*2))-(Nz([TotalStats].[PHR]*8))-(Nz([TotalStats].[PBB]*3))+(Nz([TotalStats].[PK]*5))-(Nz([TotalStats].[PHB]*3))-(Nz([TotalStats].[WP]*1))+(Nz([TotalStats].[CG]*50))+(Nz([TotalStats].[ShO]*75)) AS Points, Owners.TeamName, Players.OwnerID, Players.PositionType
  FROM Owners RIGHT JOIN (Players LEFT JOIN TotalStats ON Players.ID = TotalStats.ID) ON Owners.OwnerID = Players.OwnerID
  WHERE (((Players.PositionType)="Pitch") AND ((Players.DraftStatus)="Drafted"))
  ORDER BY (Nz([TotalStats].[W]*25))-(Nz([TotalStats].[L]*5))+(Nz([TotalStats].[PG]*10))+(Nz([TotalStats].[QS]*10))+(Nz([TotalStats].[SV]*20))-(Nz([TotalStats].[BS]*5))+(Nz([TotalStats].[Holds]*15))+(Nz([TotalStats].[GF]*5))+(Nz([TotalStats].[Innings]*3))-(Nz([TotalStats].[PH]*1))-(Nz([TotalStats].[ER]*2))-(Nz([TotalStats].[PHR]*8))-(Nz([TotalStats].[PBB]*3))+(Nz([TotalStats].[PK]*5))-(Nz([TotalStats].[PHB]*3))-(Nz([TotalStats].[WP]*1))+(Nz([TotalStats].[CG]*50))+(Nz([TotalStats].[ShO]*75)) DESC;
  </code></pre>