How can I delete from a union query. I would like to do this using the
connection.execute command line from vba.
Running Access 2002 under WinXP

UNION queries are unupdateable... no adds, no updates, no deletes.
Once the
query is UNIONed, Jet can't determine the source of a given record.

So, you'd have to add a field(s) to the query results to know the
source table.  Then you could build your sql statement using the name
of the table to delete from and execute it using the
connection.execute command.