MySQL Bugs: #12272: MS access relationships not migrated

Bug #12272	MS access relationships not migrated
Submitted:	29 Jul 2005 14:56	Modified:	29 Jul 2005 15:12
Reporter:	Frank Herrmann	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Migration Toolkit	Severity:	S2 (Serious)
Version:	1.0.11 beta	OS:	Windows (Windows XP)
Assigned to:		CPU Architecture:	Any

Description:
I migrate a MS Access 97 database that uses relationships with referential integrity (foreign key constraints). These are not migrated. here is an excerpt from the log:

-------- cut here ---------------
Fetching FK information.
SELECT szRelationship,  szColumn, szReferencedObject, szReferencedColumn, grbit FROM MSysRelationships WHERE szObject=? ORDER BY szRelationship, icolumn
Cannot fetch foreign key information.
[Microsoft][ODBC Microsoft Access Driver] Datensätze können nicht gelesen werden. Keine Leseberechtigung auf 'MSysRelationships'.
---------- cut here ---------------

The german part of the error message means 'no permission to read MSysRelationships'. The Access file password is deleted so there should be no access restrictions. Hence I changed the options in the Access file so that the table 'MSysRelationship' is visible instead of hidden but this was not the cause.

Maybe I miss something in the SQL Syntax but for me it looks like the question mark is a wildcard in a format string that was not replaced. 

How to repeat:
Use relationships with referential integrity (foreign key constraints).

Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

You have to grant access to the system tables your the MT will not be able to read this information. Please take a look at the manual where the necessary steps are described in detail.