Key Violation error

[Solomons Gap]

Dear Matthew and Responsive Software,

I am delighted with your software, and am learning more about it.

I somehow have created an error condition -- when I press the "insert" key to add a new account (in the "Maintain Accounts" dialogue box), I get an error message saying "Key Violation". The same error appears when I try to the function for "Clone Company".

-- I recopied the database, which might be a cause of this error. I have to try re-installing (which might fix it). Please let me know if you have any insight into this error.

Thanks!
Matthew Lindberg-Work
MBA, 2013
Iowa Sustainable Business Alliance

[matthew....@gmail.com]

"Key Violation" indicates corruption in the database.

 

Every record has a unique ID field that is generated sequentially whenever you add a new record.

 

If the master record for this gets reset for example by deleting the IdGenerator table this is exactly the error you will get.

 

The solution is to delete all the files in the database folder and let the program recreate a new empty database.

 

Or else restore your database from a backup copy.