Delete ALL records from multiple tables? 2

[Johnny42]

Can I Delete ALL records from multiple tables?

 

[lupins46]

Not unless they are related and have cascade delete selected.
Otherwise you have to delete records one table at a time.

 

[BNPMike]

If you use a Macro.

 

[Johnny42]

Ok thanks !

 

[Johnny42]

could I use a cascade delete trigger ?

 

[PHV]

could I use a cascade delete trigger ?
Yes, if the table are related and the RelationShips are properly set with referential integrity enforced.

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

 

[Johnny42]

Not sure I understand, however I dont think the tables are related...
I'm trying to automate the deletion of "Test" data across my DB

 

[PHV]

Why not simply write a VBA procedure with some DoCmd.RunSQL "DELETE FROM ... WHERE ..." calls ?

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