Prev: CREAR ACCESO DIRECTO
Next: MS Rant - TabIndexes
From: Lars Brownies on 23 May 2010 14:14
I did some further testing and this seems like a bug. In a new mdb I created
the following tables:

1. tblPerson: PersonID* LastName
2. tblPersonActivity: PersonID* ActivityID*
3. tblPersonAdress: PersonID* AddressID*

I linked 1 to 2 (1xM) and 1 to 3 (1xM), both with RI and cascading deletes
checked.
Table 1 has one record and there's one related record in table 2. Mind you:
Table 3 is empty.

If I delete the tblPerson's record I don't get the cascading deletes
message. If I remove the link from table 1 to 3 and try again, then I do get
the cascading deletes message.

Now if I repeat the above and first adding a record to table 3, I do get the
right message.

So if one of the relation tables is empty, you don't get the right message.

This doesn't seem like WAD.

Lars

PS: I skipped the Activity and Address tables and they don't make any
difference to the above.



"Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> schreef in bericht
news:OisEGIo#KHA.4308(a)TK2MSFTNGP04.phx.gbl...
> Are you certain your relationships are set up properly?
>
> Is there a 1 at the Person end of the relationship and an infinity sign at
> the Activity end in the Relationships diagram?
>
> --
> Doug Steele, Microsoft Access MVP
> http://I.Am/DougSteele
> (no private e-mails, please)
>
>
> "Lars Brownies" <Lars(a)Browniew.com> wrote in message
> news:htba34$2ai$1(a)textnews.wanadoo.nl...
>> A2003: Table Person linked 1 X M to table Activity. The relationship has
>> its Referential Integrity checkbox and the Cascade Delete checkbox both
>> checked.
>>
>> When I delete a person all related Activity records are deleted which is
>> to be expected. According to
>> http://www.informit.com/articles/article.aspx?p=26115&seqNum=5 I should
>> get the following message in this case:
>>
>> "Relationships that specify cascading deletes are about to cause 1
>> record(s) in this table and in related tables to be deleted. Are you sure
>> you want to delete these records?"
>>
>> In stead I get:
>> "You are about to delete 1 record(s). If you click Yes. you won't be able
>> to Undo this Delete operation. Are you sure you want to delete this
>> records?"
>>
>> Can someone explain what's going on?
>>
>> Thanks,
>>
>> Lars
>
>
From: Tom van Stiphout on 23 May 2010 18:40
On Sun, 23 May 2010 20:14:18 +0200, "Lars Brownies"
<Lars(a)Browniew.com> wrote:

I am able to confirm this behavior with A2010 accdb. This is indeed at
least weird and possibly a bug. Report it.

-Tom.
Microsoft Access MVP


>I did some further testing and this seems like a bug. In a new mdb I created
>the following tables:
>
>1. tblPerson: PersonID* LastName
>2. tblPersonActivity: PersonID* ActivityID*
>3. tblPersonAdress: PersonID* AddressID*
>
>I linked 1 to 2 (1xM) and 1 to 3 (1xM), both with RI and cascading deletes
>checked.
>Table 1 has one record and there's one related record in table 2. Mind you:
>Table 3 is empty.
>
>If I delete the tblPerson's record I don't get the cascading deletes
>message. If I remove the link from table 1 to 3 and try again, then I do get
>the cascading deletes message.
>
>Now if I repeat the above and first adding a record to table 3, I do get the
>right message.
>
>So if one of the relation tables is empty, you don't get the right message.
>
>This doesn't seem like WAD.
>
>Lars
>
>PS: I skipped the Activity and Address tables and they don't make any
>difference to the above.
>
>
>
>"Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> schreef in bericht
>news:OisEGIo#KHA.4308(a)TK2MSFTNGP04.phx.gbl...
>> Are you certain your relationships are set up properly?
>>
>> Is there a 1 at the Person end of the relationship and an infinity sign at
>> the Activity end in the Relationships diagram?
>>
>> --
>> Doug Steele, Microsoft Access MVP
>> http://I.Am/DougSteele
>> (no private e-mails, please)
>>
>>
>> "Lars Brownies" <Lars(a)Browniew.com> wrote in message
>> news:htba34$2ai$1(a)textnews.wanadoo.nl...
>>> A2003: Table Person linked 1 X M to table Activity. The relationship has
>>> its Referential Integrity checkbox and the Cascade Delete checkbox both
>>> checked.
>>>
>>> When I delete a person all related Activity records are deleted which is
>>> to be expected. According to
>>> http://www.informit.com/articles/article.aspx?p=26115&seqNum=5 I should
>>> get the following message in this case:
>>>
>>> "Relationships that specify cascading deletes are about to cause 1
>>> record(s) in this table and in related tables to be deleted. Are you sure
>>> you want to delete these records?"
>>>
>>> In stead I get:
>>> "You are about to delete 1 record(s). If you click Yes. you won't be able
>>> to Undo this Delete operation. Are you sure you want to delete this
>>> records?"
>>>
>>> Can someone explain what's going on?
>>>
>>> Thanks,
>>>
>>> Lars
>>
>>
From: Lars Brownies on 24 May 2010 01:50
Thanks. I've googled but I am not sure where to report it.

Lars

"Tom van Stiphout" <tom7744.no.spam(a)cox.net> schreef in bericht
news:fkbjv5tp9vnmhudqldimm67q6ebrqllsi4(a)4ax.com...
> On Sun, 23 May 2010 20:14:18 +0200, "Lars Brownies"
> <Lars(a)Browniew.com> wrote:
>
> I am able to confirm this behavior with A2010 accdb. This is indeed at
> least weird and possibly a bug. Report it.
>
> -Tom.
> Microsoft Access MVP
>
>
>>I did some further testing and this seems like a bug. In a new mdb I
>>created
>>the following tables:
>>
>>1. tblPerson: PersonID* LastName
>>2. tblPersonActivity: PersonID* ActivityID*
>>3. tblPersonAdress: PersonID* AddressID*
>>
>>I linked 1 to 2 (1xM) and 1 to 3 (1xM), both with RI and cascading deletes
>>checked.
>>Table 1 has one record and there's one related record in table 2. Mind
>>you:
>>Table 3 is empty.
>>
>>If I delete the tblPerson's record I don't get the cascading deletes
>>message. If I remove the link from table 1 to 3 and try again, then I do
>>get
>>the cascading deletes message.
>>
>>Now if I repeat the above and first adding a record to table 3, I do get
>>the
>>right message.
>>
>>So if one of the relation tables is empty, you don't get the right
>>message.
>>
>>This doesn't seem like WAD.
>>
>>Lars
>>
>>PS: I skipped the Activity and Address tables and they don't make any
>>difference to the above.
>>
>>
>>
>>"Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> schreef in bericht
>>news:OisEGIo#KHA.4308(a)TK2MSFTNGP04.phx.gbl...
>>> Are you certain your relationships are set up properly?
>>>
>>> Is there a 1 at the Person end of the relationship and an infinity sign
>>> at
>>> the Activity end in the Relationships diagram?
>>>
>>> --
>>> Doug Steele, Microsoft Access MVP
>>> http://I.Am/DougSteele
>>> (no private e-mails, please)
>>>
>>>
>>> "Lars Brownies" <Lars(a)Browniew.com> wrote in message
>>> news:htba34$2ai$1(a)textnews.wanadoo.nl...
>>>> A2003: Table Person linked 1 X M to table Activity. The relationship
>>>> has
>>>> its Referential Integrity checkbox and the Cascade Delete checkbox both
>>>> checked.
>>>>
>>>> When I delete a person all related Activity records are deleted which
>>>> is
>>>> to be expected. According to
>>>> http://www.informit.com/articles/article.aspx?p=26115&seqNum=5 I should
>>>> get the following message in this case:
>>>>
>>>> "Relationships that specify cascading deletes are about to cause 1
>>>> record(s) in this table and in related tables to be deleted. Are you
>>>> sure
>>>> you want to delete these records?"
>>>>
>>>> In stead I get:
>>>> "You are about to delete 1 record(s). If you click Yes. you won't be
>>>> able
>>>> to Undo this Delete operation. Are you sure you want to delete this
>>>> records?"
>>>>
>>>> Can someone explain what's going on?
>>>>
>>>> Thanks,
>>>>
>>>> Lars
>>>
>>>
 | 
Pages: 1
Prev: CREAR ACCESO DIRECTO
Next: MS Rant - TabIndexes