QuoteWerks Knowledgebase Topic (Article ID 6366)
Duplicate Values in Index - Error When Saving a Document
This information applies to :
July 23, 2019
When saving a quote, the following error occurs:
(Note: Some values may differ slightly)
'Error (-2147467259) 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 the duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
Was encountered in the MIDA_RecordsetAddRecEx function. FieldName=RecLastModifed, FieldValue=27/10/2006 09:45:42, ErrorLocation==Before.Update
The index setting for the DocumentHeaders.DocNo field of the docs.mdb file has somehow changed to "Yes (No Duplicates)", when it should be "Yes (Duplicates Ok)".
(Be sure to make a backup copy of the docs.mdb file prior to performing this task)
To check to see if this condition exists, open the docs.mdb database and click on the DocumentHeaders table and click on the Design button.
Scroll through the list of fields until you find the DocNo field, and click on it. In the Field Properties look for the "Indexed" property. Change it if needed. If you do need to change it, you may also want to look at the DocNo field value for each record in the table to see if there are any empty DocNo's. There should never be empty DocNo's. For each you find, you may want to enter a unique DocNo value.
©1993-2020 Aspire Technologies, Inc.
407-248-1481 (9am-5pm ET M-F)