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.
