By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
448,561 Members | 1,243 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 448,561 IT Pros & Developers. It's quick & easy.

how to Enforce referential integrity by using ADOX to more than 2 tables

P: n/a
Hello Sir,

i have created ms access database file by using ADOX.
in which i have created 4 tables. 1 master table and 3 child tables. in the
master table i have assigned primary key and in the child tables i have
assigned foreign key. now my problem is deleting a record in the master
table can not be deleted if there exists a record in the child tables. so,
to solve this problem i have to give the property update and delete cascade
rule by the ADOX key object.
'Enforce referential integrity is needed for me.

i need the code for this.

it is very urgent.
Thanks in advance.
Nov 21 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Gaffar,

I have TWICE given you a url to an article that has all the code in it for
working with ADOX, including code for cascade delete, etc.

Why are you still asking for this information? I have noticed several other
posters giving you answers that you seem to ignore in your next post, asking
for the same things you have already been given.

Just what's up with that? Can you neither write code nor read articles that
contain the code you need????

Kerry Moorman
"Gaffar" wrote:
Hello Sir,

i have created ms access database file by using ADOX.
in which i have created 4 tables. 1 master table and 3 child tables. in the
master table i have assigned primary key and in the child tables i have
assigned foreign key. now my problem is deleting a record in the master
table can not be deleted if there exists a record in the child tables. so,
to solve this problem i have to give the property update and delete cascade
rule by the ADOX key object.
'Enforce referential integrity is needed for me.

i need the code for this.

it is very urgent.
Thanks in advance.

Nov 21 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.