error message while migrating from access to sql (access 2010 upsize tool)

[DevAccess]

Hello I am getting below error while I am using access 2010 upsizing functionality for migrating ms access 2010 tables to sql server database.
1st error:
Relationship or Constraint Failed to Upsize: Server Error 8136: [ODBC Driver 11 for SQL Server][SQL Server]Duplicate columns specified in FOREIGN KEY constraint key list, table 'tblHoldInvPrinter'. Server Error 8139: [ODBC Driver 11 for SQL Server][SQL Server]Number of referencing columns in foreign key differs from number of referenced columns, table 'tblHoldInvPrinter'.

2nd error:
Relationship or Constraint Failed to Upsize: Server Error 1776: [ODBC Driver 11 for SQL Server][SQL Server]There are no primary or candidate keys in the referenced table 'tblOrderDetailsInfo' that match the referencing column list in the foreign key 'tblHoldInvVendBH_FK00'. Server Error 1750: [ODBC Driver 11 for SQL Server][SQL Server]Could not create constraint or index. See previous errors.



Could anybody help on this ? this happens for several tables.

 

[jleach]

It may be easier to ignore all of the relationships that are currently set up in Access, and re-apply them manually after the migration is complete.

Aside from the issue you're seeing here, SQL Server is more strict about circular relationships than Access is, so in many cases a "matured" Access database will have to have a number of FK constraints dropped to be valid for MSSQL anyway.