Does Cascade Delete work after you Upsize Tables to SQL?

[mystuff]

I have upsized my tables to SQL. Now, a DBA is maintaining the production tables and I maintain the Access front end.

Can relationships be set in Access to enforce referential integrigty to SQL tables? Or do the relationships have to be set within SQL.

Also, with regards to "Cascade Delete" is there a 'Cascade Delete" option in SQL relationships? If this is set in SQL, will children records get automatically deleted if the parent record is deleted? Or do I need to write code to delete the children.

Thanks for your help.

 

[psemianonymous]

Ask your DBA. The answer is that there is definitely a CASCADE DELETE option for SQL Server, and if you have the security rights to check the table design you will be able to find it--but the easy way is just to ask your DBA. --Peter

 

[PHV]

For me, the standard (and safer) way is to have ALL the triggers in the back-end.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886