Article Details
Id:8698
Product:finPOWER Connect
Type:NEW
Version:1.03.02
Opened:21/04/2011
Closed:21/04/2011
Released:23/05/2011
Job: J007311

Copying an Access database to SQL Server fails when attempting to create relationships for Access system tables

When an Access database is opened in either Access 2007 or 2010, extra system tables and relationships are created behind the scenes.

If you then attempt to copy one of these databases to SQL Server, it will fail when attempting to create relationships.

The business layer code that retrieves schema information about Access database now ignores system relationships.