QuoteWerks Knowledgebase Topic (Article ID 6003)
Database - Duplicate Key when saving in QuoteWerks
This information applies to :
December 24, 2015
When saving a document in QuoteWerks you receive the following or other similar messages involving a duplicate key:
The error(-2147467259) Operation must use an updateable query, was encountered in the MIDA_RecordsetEditRec function.
Error occurred at .Update method
QuoteWerks was unable to write the updated next available number sequence for QUOTE Do you want to try again?
Runtime error 3219:
Operation is not allowed in this context
1. Verify all users have Full Control rights to the QuoteWerks installation folder under Windows permissions. That's Read, Write and Modify rights.
2. If all users do have confirmed Full Control, try running Maintenance on the DOCS.MDB file. Go to Start -> Programs -> QuoteWerks -> Tools & Information -> Medic Utility then click the Maintenance button, select the Docs database and click Start.
3. If that also does not resolve the problem, in some cases we have seen the index setting for the DocumentHeaders.DocNo field somehow change to "Yes (No Duplicates)", when it should be "Yes (Duplicates Ok)". To verify this, open the database in Access 2002/2003/2007/2010/2013(Note: You can open in any version of MS Access 2002 or higher, however, do not convert the database to the new format it must remain 2002/2003 formatted.), click on the DocumentHeaders table and click on the Design button. Then 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, so 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)