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.