Background

Total Access Analyzer is the world's leading Microsoft Access add-in product and designed to help you create better Microsoft Access solutions through comprehensive documentation and analysis. Total Access Analyzer offers more than 380 Reports, making it the most power documentation and analysis program for Microsoft Access professionals. 

Problem

Error Description

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. 

Solution

Error Cause

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:

1. Does the crash occur on every database you try to document?
2. If it only fails for a particular database, please provide us a copy of the database.
3. Let us know what documentation options you selected.
4. 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.

Additional Support Resources

• Support Options
• Product Information
• FAQs
• Updates
• User Manual
• PDF Fact Sheet