Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Multiuser > Integrity Fails...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 4 Topic 2117 of 2176
Post > Topic >>

Integrity Fails !!!

by "SANJAY SHAH-MICROBRAIN COMPUTERS PVT. LTD." <microbrain@[EMAIL PROTECTED] May 10, 2008 at 02:13 PM

Dear Sir,

In my database I am relating tales & I select enforce referential
integrity 
and I select cascade delete related record.

In my application I delete record from parent table so because of cascade 
delete it is deleting from child table. It works fine but I found in some 
case under network it is deleting table from parent but not from child !!!

If I compact database then it breaks relation****p of parent & child and
then 
it is very difficult to delete record from child.

If I had defined referential integrity & cascade delete then it must
delete 
record from child when I compact database.

Please any one tell me why this is happening & what is solution. ?

Thanks,

Sanjay Shah
 




 4 Posts in Topic:
Integrity Fails !!!
"SANJAY SHAH-MICROBR  2008-05-10 14:13:14 
Re: Integrity Fails !!!
"Albert D. Kallal&qu  2008-05-10 13:30:34 
Re: Integrity Fails !!!
"Tony Toews [MVP]&qu  2008-05-10 17:02:39 
Re: Integrity Fails !!!
"aaron.kempf@[EMAIL   2008-05-14 19:05:25 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Thu Nov 20 0:22:57 CST 2008.