Referential Integrity with ADOX RRS feed

  • Question

  • Hi,


    I'm trying to modify foreign key relationships in an Access 2000 database through VB.NET code using ADOX interop. I can read/set the properties of the columns, tables just fine, yet I can't find how to set (and determine) the referential integrity property of the relationships, which is visible in Access UI.


    As I learned, the relationships themselves can be found under ADOX.Tables.Keys collection yet it doesn't offer a bit to enable/disable referential integrity. The only thing I've discovered so far that enabling referential integrity in Access UI creates an additional index for the foreign table but, I guess, this is a very poor workaround.


    Anyone knows where the actual "enable referential integrity" property is hidden?



    Tuesday, June 19, 2007 7:57 PM