When working in GIFTS with a Microsoft Access database backend, users may encounter an error similar to the following:
Technical Support Info: [SQLExecutable] 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 duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.
This message is sometimes preceded by the generic [WriteRow] Error # -4 message. Errors #-2147467259 and #-4 are generic messages that can be caused by a variety of issues. This article only applies if these errors are accompanied by text about creating duplicate values in the index, primary key, or relationship. Most often, the cause of this behavior is that there is a problem with the indexing of a GIFTS database table.
To resolve, we suggest taking the following steps:
1. Make sure all users have backed out of GIFTS 2. Backup your database 3. Open the Administrator Module and go to Tools > Recalculation Utility 4. Check off the options below: Initialize Keys Insert Zero Records Update Foreign Keys Refresh Codes Table Repair Indices 5. Run the utility until it is completed
Once completed, check to see if the error still appears. If not, the issue is resolved. If it does still appear, Please contact us with the customer support number for GIFTS listed at https://www.blackbaud.com/contact-us/ which will always have the most up to date information,