title: MS 2010 Access Primary Key changes upon DB publication to the web?
body: <p>I am quite new to MS Access 2010 and so I have some issues I don't quite understand...</p>
  
  <p>I have an MS Access 2010 DB that I have published to a Sharepoint 2010 server. I noticed that when I publish my DB to the web, the primary key on my main table (and main form) gets changed. </p>
  
  <p>I have googled and searched on here to find an answer but no one has been able to answer why upon publishing a DB to the web causes the primary keys to change. </p>
  
  <p>Example:</p>
  
  <p>Primary key ID Num BEFORE web publication: </p>
  
  <pre><code>                  ID Num: 11111 
                    ID Num: 22222
                    ID Num: 66666
  </code></pre>
  
  <p>Primary key ID Num AFTER web publication:  </p>
  
  <pre><code>                  ID Num: 1
                    ID Num: 2
                    ID Num: 3
  </code></pre>
  
  <p>Why does this happen? </p>
  
  <p>My subforms rely on the PK ID Num 11111, 22222, 66666 to display the information associated with it in the other tables but because the PK gets changed (to an autonumber it seems), my forms aren't properly displaying the correct information in the web published version of the DB. </p>
  
  <p>I also noticed some of my other columns of data gets changed from ##### to ##,### format in the web published DB. It's quite odd. Any assistance would be greatly appreciated. Thanks!</p>