title: MS Access duplicate record error
body: <p>I am struggling with MS Access duplicate record error. I am getting this error on some of the records while doing inserts. The exact error is "The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again".</p>
  
  <p>The interesting part is that while running the same data set I get errors on different records each time. I removed the indexes in a destination table but still the same issue. I read that it might be MS Access glitch, so I created identical table in SQL Server and attempted the insert - worked like a charm.  So it seems it is Access issue. Is there any workaround? I have tried to find one but so far no luck. Would appreciate if someone could point me to the right direction as of now changing databases would not be an option.
  Thanks.</p>
  
  <p>P.S. My primary key is a composite key of Name (text), Key (text) and LineNo (integer). There could be mnore than one key with the same name per each Name fields but different Line number.</p>