title: Id field (primary key) is skipping numbers of rows that have been deleted, how to change?
body: <p>I'm using MS Access and have created a simple table. I have one column as the standard <code>ID</code> primary key (renamed to <code>Number</code>). I deleted a selection of rows, but now when I go to the next row, the <code>Number</code> column counts from the deleted numbers. </p>
  
  <p>E.g. it looks like:</p>
  
  <pre><code>Number Name
  1       etc
  2       etc
  3       etc
  6       etc
  7       etc
  8       etc
  </code></pre>
  
  <p>Where rows 4 &amp; 5 have been deleted.</p>
  
  <p>I removed all the rows that came after the problem (i.e. 6,7,8 in this case) but then it starts from 9.
  Is there any way I can start the count back at 4 (as I have rows 1,2,3 left)?</p>