I'm using an Ms Access database which should be modfied but Im not sure as to what I shoud modify. When adding data to the table and trying to safe I get an EOleException stating that the entered data causes duplicate values for either the index, primary key or relation. Furthermore it suggests to alter the fields which are in conflict or redefine the index. Now the program shouldnt complain when two fields are the same, for instance city will often be the same amongst others.
Can anyone take a look and see what is wrong?