More efficient way of running multiple update queries on an Access database? <p>I have multiple queries like this right now which involve updating different fields of the same row in an Access database:</p> <pre><code>//Update database string updatequery = "UPDATE [table] SET [Last10Attempts] = ? WHERE id = ?"; OleDbConnection con = new OleDbConnection(@"Provider=Microsoft.ACE.OLEDB.12.0;" + @"Data Source=" + "database.accdb"); con.Open(); OleDbDataAdapter da = new OleDbDataAdapter(updatequery, con); var accessUpdateCommand = new OleDbCommand(updatequery, con); accessUpdateCommand.Parameters.AddWithValue("Last10Attempts", last10attempts); accessUpdateCommand.Parameters.AddWithValue("ID", currentid + 1); da.UpdateCommand = accessUpdateCommand; da.UpdateCommand.ExecuteNonQuery(); //update last10attemptssum updatequery = "UPDATE [table] SET [Last10AttemptsSum] = ? WHERE id = ?"; accessUpdateCommand = new OleDbCommand(updatequery, con); accessUpdateCommand.Parameters.AddWithValue("Last10AttemptsSum", counter); accessUpdateCommand.Parameters.AddWithValue("ID", currentid + 1); da.UpdateCommand = accessUpdateCommand; da.UpdateCommand.ExecuteNonQuery(); //increment totalquestionattempt updatequery = "UPDATE [table] SET [total-question-attempts] = ? WHERE id = ?"; accessUpdateCommand = new OleDbCommand(updatequery, con); accessUpdateCommand.Parameters.AddWithValue("total-question-attempts", questionattempts + 1); accessUpdateCommand.Parameters.AddWithValue("ID", currentid + 1); da.UpdateCommand = accessUpdateCommand; da.UpdateCommand.ExecuteNonQuery(); con.Close(); </code></pre> <p>I was wondering if there is a more efficient way of running these update queries - ie. combining them into one query.</p>