E
Eric
I run append queries from a 4 temporary tables to 4 permanent tables. After
the append, I'd like to run a Delete Query after the append queries, that
will delete all records in all 4 temporary tables.
I've looked at some ideas and code from others, but I'm not needing any
fault attributes. I am sure of the append functions and am sure I want the
records deleted.
Here is some code I am trying with only two tables, but I get an error "you
can not delete from the specified tables"
DELETE [1ReviewHDR].*, [2ReviewBPS].*
FROM 2ReviewBPS, 1ReviewHDR;
Any help would be great.
the append, I'd like to run a Delete Query after the append queries, that
will delete all records in all 4 temporary tables.
I've looked at some ideas and code from others, but I'm not needing any
fault attributes. I am sure of the append functions and am sure I want the
records deleted.
Here is some code I am trying with only two tables, but I get an error "you
can not delete from the specified tables"
DELETE [1ReviewHDR].*, [2ReviewBPS].*
FROM 2ReviewBPS, 1ReviewHDR;
Any help would be great.