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

Article translations Article translations
Article ID: 966136 - View products that this article applies to.
Expand all | Collapse all

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.

CAUSE

There is corruption in the specification set.

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

Properties

Article ID: 966136 - Last Review: January 27, 2009 - Revision: 1.0
APPLIES TO
  • Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
  • FRx Financial Reporter 6.5
Keywords: 
KB966136

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com