none
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?

     

    Thanks

    Tuesday, June 19, 2007 7:57 PM