407-248-1481

QuoteWerks Knowledgebase Topic (Article ID 6366)

Duplicate Values in Index - Error When Saving a Document

This information applies to :

Article ID
6366

Created/Updated
July 23, 2019

Category
Troubleshooting


Are you using the most current release of QuoteWerks?
Version 5.5 Build 1
Issue:

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



Cause:
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)".


Solution:
(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.

New Search