HomeStar Check WriterErrorsError - DBISAM Engine Error # 9729 Duplicate key found in the index 'Default' of the table 'ctrl'

10.7. Error - DBISAM Engine Error # 9729 Duplicate key found in the index 'Default' of the table 'ctrl'

Error - DBISAM Engine Error # 9729 Duplicate key found in the index 'Default' of the table 'ctrl'

If you are receiving this error message while adding or editing an Account record, this means you have a duplicate record in the table.

The table has an index that is used to define it's uniqueness to the other records in the table. You already have a record with the same account number in this table.  So if you are adding a record, you need to change the Account number to something that is different from the one that is already in the table. Then you can proceed in adding the new Account record to the system.

If you already added the duplicate record, you will see two or more records in the displayed grid that are identical as far as the Account number. You will need to either Delete the duplicate(s), or change the Account number, and then you should be good to go.

*Important - if you change an Account number, you will lose any associated history assigned to the original Account number, as the Transaction History and Checks written are assigned to the Account number.

This page was: Helpful | Not Helpful