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

G

Gaffar

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.
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

creating realtionships in msaccess database by using adox 2
how to establish relationsips(one-many) by using adox 2
still i couldn't got my answer 1
Enforce Referential Integrity 1
Enforcing referential integrity across databases 5
establishing realtionships by using ADOX 3
Referential Integrity 3
Referential Integrity 4

Top