We have received a few reports of this error when Total Access Analyzer is documenting your Access database. This crash is very frustrating as the documentation generated up to that point is not useable.
The Error Number is 3022 with this full description:
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.
The error is generated by Microsoft Access when it can't add a new record to a table with values that conflict with an existing record. This happens while Total Access Analyzer is writing your database's documentation to its output Access database.
Unable to Replicate the Crash
Unfortunately, we have not been able to replicate this problem. Our product should never add records to a table that creates a duplicate value conflict. As a result, we have been unable to resolve this problem.
Work-Around: Try Again
Fortunately, this crash only appears rarely. Customers who reported this seem to be able to exit Access, re-open their database, and re-run Total Access Analyzer to successfully generate the results. In some cases, rebooting the machine resolves the problem.
This is very odd, since the documentation uses a new output database and puts the same data into the same tables each time it's generated. The crash should repeat over and over again, but it doesn't.
Make sure you have the latest build of your version of Total Access Analyzer. Visit the Update Page to see the latest version or run the program's Update Wizard from the Windows menu.
Let Us Know if You Can Reproduce This
After rebooting your machine, if this error occurs each time you document your database, we would love to work with you to address the problem. In particular, we'd like to know:
- Does the crash occur on every database you try to document?
- If it only fails for a particular database, please provide us a copy of the database.
- Let us know what documentation options you selected.
- Give us a copy of the log generated from the About form in Total Access Analyzer.
Provide this information in a support ticket on this site. Thanks for your help.