title: How to rename primary key value in Access DB
body: <p>I have a MS Access DB with a primary key on the parent table and 82 other tables.
  New data will be coming with new name for the primary key</p>
  
  <pre><code>Before      New
  RS182       X182RS
  RS188       X188RS
  RD301       X301RD
  </code></pre>
  
  <p>Is there a way to rename the primary key value in bulk on all the tables in the DB because I want to associate all previous historical data to the new name value. </p>