I've been using Excel VBA and ADO to practice SELECTing and FILTERing records from an MDB file. I used the following code to change values in certain records and was surprised that the MDB file had been updated. Is this normal behavior? I thought the recordset existed in memory only and the UPDATE command was needed to actually save the results to the DB.

Code:
rs.Filter = "FIELDA = NULL"

Do While Not rs.EOF
   rs.Fields("FIELDA").Value = rs.Fields("FIELDB").Value
   rs.MoveNext
Loop