Adding relationships between tables using ADODB and ADOX

From: Jerommeke (jeroenvv_at_home.nl)
Date: 03/23/05

  • Next message: SBC: "Re: Runtime error 3707" 
    Date: Wed, 23 Mar 2005 18:40:38 +0100

    Hello

    I am working on a C# databaseproject using ADO .NET
    Today I discovered that ADO .NET can not create permanent table columns
    and/or table relations. I need to do that because when I release a new
    version of my software, old databases need to be upgraded.

    I solved the problem for the columns by using an SQL statement, and later I
    realized another solution by using ADOX en ADODB through COM
    interoperability.

    However, I don't seem to find a useful example that shows me how to
    programatically add a permanent relationship in a database using ADOX and/or
    ADODB

    can anyone help me with a useful example??

    regards

    Jeroen van Vlierden

  • Next message: SBC: "Re: Runtime error 3707"