Act conversion

Hi Im converting our Act 6 database to Act9 and I keep getting this error
right near the end of conversion.
Converting Notes and Histories...
The INSERT statement conflicted with the FOREIGN KEY constraint
"NOTE_CREATEUSERID_FK". The conflict occurred in database "MTA2008", table
"dbo.TBL_ACCESSOR", column 'ACCESSORID'.
The statement has been terminated.
I am a bit stuck with this error plz if anyone can help fix this would be
appreciated.
Thanks.

On Wed, 1 Aug 2007 23:22:02 -0700, Daz wrote:

>Hi Im converting our Act 6 database to Act9 and I keep getting this error
>right near the end of conversion.
>Converting Notes and Histories...
>The INSERT statement conflicted with the FOREIGN KEY constraint
>"NOTE_CREATEUSERID_FK". The conflict occurred in database "MTA2008", table
>"dbo.TBL_ACCESSOR", column 'ACCESSORID'.
>The statement has been terminated.
>I am a bit stuck with this error plz if anyone can help fix this would be
>appreciated.
>Thanks.

Hi Daz,

A foreign key constraint implies that each value inserted in a specific
column or set of columns (in this case the column ACCESSORID in the
table dbo.TBL_ACCESSOR) has to be present in another table (the error
message doesn't tell us which table that is; you'll have to find out by
examining the constraint yourself).

You are getting this error message because, apparently, at least one of
the value you are trying to insert does not fulfill this requirement.

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis