I have a table in micorsoft access with many fields one of which is an ID field. This ID field is an autonumber set to incriment.
recently there has been a problem with this ID field as it keeps duplicating ID numbers the ID is indexed but it is set at duplicates ok the simple solution might...