I have a table that contains a primary key and I am trying to append records from a text file. When I go to append the records, it tell me that XXX amount of records were lost due to key violations. Can anybody explain why this is happening? Shouldn't access be able to figure out how to create new ID's on newly appended data?
Access 2007