When trying to save to a layer, you may get this error:
The changes you requested to the table were not successful because they would create duplicate values in the index, primary key or relationship.
This happens because the record being saved to the layer is being saved to a Microsoft Access database whose autonumber values are corrupt, causing the new record to be saved with the same number as an existing record (which should be an unique number).
The solution is to reset what Microsoft thinks is the next available unique number, or use a different layer/table. There are 3 options available to you to fix this this problem:
- Delete all existing data in the problem layer then repair the database (MDB) – Right mouse click on the layer in the Quickmap layer control tool, Select Delete Features in this layer then click the All button. After all data has been deleted, select Tools -> Diagnose/Repair -> Compact database and choose the problem layer to compact. If these options are not available in your current version of Quickmap, you will need to update to the latest version.
- Zip the database (MDB) up and send it to Custom Software for repair. If you right mouse click on the layer in the Quickmap layer control tool, then select Properties it will display the full path of the MDB to send Custom Software on the top line, labelled Database. This option will allow Custom Software to repair the database for you without you having to delete any data.
- Create a new layer in Quickmap by select File -> New Layer then import the data into that new layer. This option will not repair the existing database table’s Autonumber corruption, but will allow you to add/import the data you want to the new layer.