Error 1452: Cannot add or update a child row: a foreign key constraint fails. September 11, 2014 06:19 Updated The error 1452 occurs only in a trial version of the DBSync for MS Access and MySQL. The software is unable to build the accurate structure of foreign keys because of 50 first records limitation. Related articles Index and Foreign Keys Options. Autodetection of potential migration issues. Errors and Warnings Tuning tips for DBConvert Studio Tables Options Database Options Comments 0 comments Please sign in to leave a comment.