Delete records from multiple tables

G

Guest

How do you delete all records from multiple tables in query design view. I
have several tables that i just want to remove all records at once from a
delete query and i receive a specify table of the records to be deleted!
 
G

Guest

You might try this (if the data in multiple tables are related) -- Tools >>
Relationships >> Right-Click to show Tables -- add Tables, and establish a
join amongst them, then Right-Click on the Join >> Edit Relationships, and
choose "Cascade Delete Related Records"

HTH
=======================
 
G

Guest

My tables are all related.I am in query design view...I add the tables...the
cascade delete related related records is checked.I try to run the delete
query by chosing one table and placing it on the grid and i use * criteria to
delete all from this table. I am new to this but something is
missing....please advise thks
 

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

Linked SQL Tables don't report Cascading Updates and Deletes 2
Question abt delete qry! 3
Access Dcount (multiple criteria) 3
Running Query In VBA, Bypassing Warnings? 7
Wrong message with cascading deletes 13
Delete all records 2
Delete records based on a union query 1
DELETE FROM a table WHERE... 1

Top