Getting Error Message

[Kokie]

I'm getting an error message when I try to update my data. I'm importing from a Microsoft Access DB, which I have done numerous times to this same database folder. This is the error message I keep getting though:

Quote:

DBMS Information: ACCESS

Importing table schema: Asmnt_Parcel… Successful…

Importing table foreign keys: Asmnt_Parcel…

ERROR in SQL:

SELECT szRelationship, szColumn, szReferencedObject, szReferencedColumn, grbit FROM MSysRelationships WHERE szObject= 'Asmnt_Parcel' ORDER BY szRelationship, icolumn

ERROR: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysRelationships'.

Check …..SQLyogsja.log for complete error details.

ERROR in SQL:

SELECT szRelationship, szColumn, szReferencedObject, szReferencedColumn, grbit FROM MSysRelationships WHERE szObject= 'Asmnt_Parcel' ORDER BY szRelationship, icolumn

ERROR: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysRelationships'.

Check …..SQLyogsja.log for complete error details.

Successful…

Importing table data: Asmnt_Parcel…

ERROR: 1054, Unknown column in 'field list'

Table:Asmnt_Parcel

Why would it be doing this? I've uploaded this same kind of content before with no problems.

Thanks!

[ashwin]

Hello,

Quote:

ERROR: [Microsoft][ODBC Microsoft Access Driver] Record(s) cannot be read; no read permission on 'MSysRelationships'.

The “MSysRelationship” is an Access system table. It must be readable for SQLyog to migrate Access 'relationships' to MySQL 'Foreign Keys'. By default, read access to the system tables of an Access database is restricted for external applications.

Please refer the link: http://www.webyog.com/en/whitepapers/Preparing_Access__Migration.pdf

Regards,

Ashwin A

[Kokie]

Thank you! That fixed the problem :).

[Author]

Posts