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

Hi,

Any luck with this issue? I know its been months but i hope you could
shed some light to this cause i've been stucked with the same issue for
hours now.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

Any luck with this issue? I know its been months but i hope you could
shed some light to this cause i've been stucked with the same issue for
hours now.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

Any luck with this issue? I know its been months but i hope you could
shed some light to this cause i've been stucked with the same issue for
hours now.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

Any luck with this issue? I know its been months but i hope you could
shed some light to this cause i've been stucked with the same issue for
hours now.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

Any luck with this issue? I know its been months but i hope you could
shed some light to this cause i've been stucked with the same issue for
hours now.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

Any luck with this issue? I know its been months but i hope you could
shed some light to this cause i've been stucked with the same issue for
hours now.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

Any luck with this issue? I know its been months but i hope you could
shed some light to this cause i've been stucked with the same issue for
hours now.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***

Hi,

Any luck with this issue? I know its been months but i hope you could
shed some light to this cause i've been stucked with the same issue for
hours now.

Thanks!

*** Sent via Developersdex http://www.developersdex.com ***