Delete Records from Linked Primary Table Only

  • Thread starter Thread starter Tonymac12
  • Start date Start date
T

Tonymac12

How can I delete records from a link primary table without deleting records
from related tables?
 
Not exactly clear what you are aiming for.

Using Northwind as an example, you want to delete a customer, but not delete
their orders? If so, it is possible to programmatically set up the relation
between Customers.CustomerID and Orders.OrderID so it has a Cascade To Null.
When a customer is deleted, the CustomerID in Orders table becomes Null, so
it does not have the deleted CustomerID, but the information about the order
is not lost. This is only possible in JET 4 (Access 2000 and later).

If that's what you are wanting to do, you will have to create the relation
programmatically using ADOX. The interface cannot create or identify this
kind of relation. Post back if you need details.
 
I am using a linked table to get customer name and ID number for tables in a
2nd Database. I do not want to delete customer info in the 2nd DB when I
delete the customer name and ID number in the linked table. The DB is Access
97.
 
If the two tables are in different mdb files, there is no relational
integrity enforced between the two. No cascading deletes. No integrity
checks. You can delete from one table without affecting the other.

Seems like I'm not understanding the issue here.
 
There is a lookup table that has relational integrity enforced with the linked
table. When I delete customer info from the linked table the customer info is
deleted in tables in the 2nd database.
 
There is a lookup table that has relational integrity enforced with the linked
table. When I delete customer info from the linked table the customer info is
deleted in tables in the 2nd database.
Click to expand...

This will happen if you have checked "Cascade Deletes" in the
relationship window. Uncheck it if you want to have the customer info
kept.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Delete Query: Could not delete from specified tables 0
manual deletion of records in datasheet based on joined tables 5
Trying to delete records from multiple tables 2
Counting the sum of related records for a primary record 4
Using Append Queries with Linked Tables 3
"Specify the table containg the records you want to delete" messag 3
deleting related records at once 2
Access 2010 append query to SQL is very slow 0

Back
Top