I'm receiving the following information only on one database I have. It just started giving this error. When I try to delete the encounter, it says its in use by another user but I'm don't have multiple users. I have tried reinstalling with no luck.
DBISAM Engine Error #9729 Duplicate key found in the index "Primary" of the table "Encounteritems"
A duplicate key error means that the data has been damaged and needs to be repaired.
Here is a short explanation of how to repair the database:
A power outage or other event can damage the Practice DATA set causing error messages. While data damage is not the only cause for an error message, many error messages can be cleared by performing a data repair.
NOTE: To avoid data error messages, our system requirements page states the following
Install an Uninterruptible Power Supply (also called a UPS or battery backup) for each computer, then connect computers, printers, displays and network equipment to the battery-protected outlets. A UPS protects against damage caused by power fluctuations and power failures.
To perform a data repair follow the steps below:
From the server computer's Windows Start button, navigate to Start>All Programs>NowMD>Database Administrator.
Once the Database Administrator Opens, choose the Data Maintenance tab.
Choose the practice name data set.
Choose the REPAIR DATA NOW button.
You will either see two scroll bars progressing as the data repairs or you will see an error message in the lower left corner of the Database Administrator screen. The error message will read "Exclusive Access is Required". This means that something (some process) is still accessing the database.
NOTE: Sometimes it's just as easy to restart the server computer and then follow the data repair steps.
Once the data repair has completed you will see a verification message in the lower left corner of the Database Administrator stating "Data was repaired if necessary."
Open NowMD and try the same task again that created the error message to confirm the problem is resolved.
The database administrator is not a tab. It's a separate program on the computer. You can also navigate to C:\Program Files (x86)\ADBServer and there you will find DBADMIN. That is the short name for the database administrator.