I have a form with a procedure that updates all records in the data set. Using SQL is the most efficient way to do this (rather than looping through the form's recordset). But if I use CurrentDb.Execute strSQL, the form barks at me about another user altering the recordset. Is there a way to run the SQL within the scope of the form? Perhaps a DAO or ADO command?