06-10-2013 11:22 AM
I'm evaulating Act 2011 for 30 days but I can't get it to convert our old Act 6 db.
Below is the error that I'm getting.
Converting Notes and Histories...
The INSERT statement conflicted with the FOREIGN KEY constraint "NOTE_MANAGEUSERID_FK". The conflict occurred in database "MPC", table "dbo.TBL_ACCESSOR", column 'ACCESSORID'.
The statement has been terminated.
How do I fix this error if possible?
I used the scan and repair database tool in actdiag and it passed with all green check marks.
Thanks for any help.
06-10-2013 01:21 PM
The ACTdiag scan and repair only checks for problems with linking between tables, it doesn't fix any data errors which it appears that is what you have. You can try creating an empty copy of your database and importing everything from you existing database into the empty copy. That will sometimes resolve data erors. The other option is to send the database to a repair service for a full repair. Our database repair serivce is listed on our web site www.techbenders.com