Hi Roy,
Thanks for the tips. They got me started, and I was able to remove the Access relationships. I used C#.NET and ADO 2.0 so there are some differences to the code. In case anyone is interested here is the way I retrieved the names of the database constraints:
OleDbConnection Connection...
Hi,
I am interested in using a program to modify relationships that are defined in an access database, for a database update script.
Example:
I have 2 tables:
ValidNumbers:
fields: ID, Num
and
Numbers: ID, Number
ValidNumber.Num has a one to many relationship to Numbers.Number meaning...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.