title: MS Access Int and Sql Server Big INT
body: <p>We have a database in Sql Server 2005 with MS Access as front end. The back end was initially in access and later transferred to Sql server.</p>
  
  <p>One of the fields in the tables in sql server has data type int with primary key. Now I believe int data type of access has limitations of 32767 being the largest integer. </p>
  
  <p>The field has auto-increment set with primary key and it has reached the figure 32767. </p>
  
  <p>I tried changing the data type from int to bigint but on the front end access started throwing all kind of errors. One of the error being "Data Type Mismatch".</p>
  
  <p>Thanks
  Yogi.</p>