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


"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.


There is corruption in the specification set.


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


Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.