Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Run-Time Error '3022': The Changes you Requested to the Table were not Successful


Symptoms

"Run-time error '3022': 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."This error occurs when saving changes to a report or generating a report.

↑ Back to the top


Cause

There is corruption in the specification set.

↑ Back to the top


Resolution

Compact the Current Spec Set. See Compacting an FRx Database. If the compacting fails, please contact FRx Support to repair the file. If the compacting succeeds, but the report component still gives the error message, you should either try to export the component into a new specification set or recreate the component. See How to Import and Export a Specification Set

↑ Back to the top


References

↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 966136
Revision : 7
Created on : 9/2/2020
Published on : 9/2/2020
Exists online : False
Views : 65