<div>
Your SQL Server table is related to another table, and referential integrity is set, so the delete fails. <br />
<br />
&gt;In Access the &quot;child&quot; records got deleted along with the parent records.<br />
Check that the delete was successful. &nbsp;It may also not be the only relationship.
</div>


Your SQL Server table is related to another table, and referential integrity is set, so the delete fails.

>In Access the "child" records got deleted along with the parent records.
Check that the delete was successful.  It may also not be the only relationship.

<div>
Can you please direct me on how to set up &quot;ON DELETE CASCADE Foreign Key Contraint&quot;?
</div>


Can you please direct me on how to set up "ON DELETE CASCADE Foreign Key Contraint"?

<div>
This link describes it in detail: <a href="http://www.mssqltips.com/sqlservertip/1296/the-importance-of-sql-server-foreign-keys/" rel="ugc">CASCADE DELETE</a>
</div>


This link describes it in detail: CASCADE DELETE [http://www.mssqltips.com/sqlservertip/1296/the-importance-of-sql-server-foreign-keys/]

<div>
I got it! Thanks for your help!
</div>


<div>
<div class="content wysiwyg-content">
I am confused about what is happening here... I can delete some records from within the table directly -- but there are 2 records I cannot delete via the linked connection. So -- I went into the table directly in the SQL Server -- and am getting a referential integrity error - there are child/related records that need to be deleted.<br />
<br />
How do I set that up on the SQL Server? In Access the &quot;child&quot; records got deleted along with the parent records.<br />
<br />
Thanks for your help.<br />
<br />
Eileen
</div>
</div>


I am confused about what is happening here... I can delete some records from within the table directly -- but there are 2 records I cannot delete via the linked connection. So -- I went into the table directly in the SQL Server -- and am getting a referential integrity error - there are child/related records that need to be deleted.

How do I set that up on the SQL Server? In Access the "child" records got deleted along with the parent records.

Thanks for your help.

Eileen

ODBC SQL Server --  Delete on Linked table failed

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.

Microsoft Development

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.