Referential Intergity Problem between Access & MySQL
I have an ODBC linked access 2007 db to a mysql inno back-end. The back-end has the proper foreign keys/cascades for referential integrity. However, I cannot setup the same reference relationships in Access. The referential integrity check boxes are grayed out in the 'Edit Relationships' pop-up window.
Any ideas on why this is not working?
Second question! Is there a better front-end than MS Access? I find the myPhPadmin interface a pain to use when updating records.
Thanks in advance.
Subject
Views
Written By
Posted
Referential Intergity Problem between Access & MySQL
3305
May 12, 2010 04:24PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.