title: Change all values in a field in a MS Access database to a constant
body: <p>I have a MS Access database with 100 tables, each has a field named "M_ID"
  I want all the values in the field named "M_ID" in each table to be set to a constant, for example "1"
  how can I do that using VBA?</p>