I've never tried this....but from what Nick is saying it looks as though if
you choose to Upsize
Table Relationships with Triggers rather than DRI it will automatically
create the required triggers for you. Try it and let us know what
happens!!!
------------------------------------------------------------------
Andrew Ewings
Project Manager
Thoughtbubble Ltd
------------------------------------------------------------------
-----Original Message-----
From: sebastian palmigiani [mailto:[EMAIL PROTECTED]]
Sent: 06 September 2000 15:14
To: [EMAIL PROTECTED]
Subject: Re: Access 2000 to SQL Server 7.0
OK. cascading deletes = bad :-)
But what about cascading updates when you do the upsizing from Access 2000
to SQL Server 7.0? Does that relationship get automatically maintained also?
Sebastian
on 9/6/00 9:01 AM, Andy Ewings at [EMAIL PROTECTED] wrote:
> Damn right Nick....Cascading deltes can be a very dangerous thing!
>
> ------------------------------------------------------------------
> Andrew Ewings
> Project Manager
> Thoughtbubble Ltd
> ------------------------------------------------------------------
>
>
> -----Original Message-----
> From: DeVoil, Nick [mailto:[EMAIL PROTECTED]]
> Sent: 06 September 2000 14:50
> To: '[EMAIL PROTECTED]'
> Subject: RE: Access 2000 to SQL Server 7.0
>
>
>> Say you define table relationships with cascacading updates or
>> cascading deletes in Access 2000. With the upsizing wizard do
>> the cascading updates and cascading deletes also get transferred
>> to SQL Server 7.0 or do you have to create triggers?
>
> Sebastian
>
> SQL Server doesn't have the concept of cascading updates & deletes
> built in the way Access does. But as you say, you can achieve
> the same effect with triggers. The Upsizing Wizard does supposedly
> create the required triggers automatically if you choose to Upsize
> Table Relationships with Triggers rather than DRI (Declarative
> Referential Integrity). DRI doesn't do cascading updates & deletes.
>
> I haven't tried it myself though! (Never trusted them in Access
> in the first place...)
>
> Nick
>
>
> **********************************************************************
> Information in this email is confidential and may be privileged.
> It is intended for the addressee only. If you have received it in error,
> please notify the sender immediately and delete it from your system.
> You should not otherwise copy it, retransmit it or use or disclose its
> contents to anyone.
> Thank you for your co-operation.
> **********************************************************************
>
----------------------------------------------------------------------------
> --
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
> the body.
>
----------------------------------------------------------------------------
--
> Archives: http://www.mail-archive.com/[email protected]/
> To Unsubscribe visit
> http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
> send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the
> body.
>
----------------------------------------------------------------------------
--
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
