Make-table issues -- on error, I don't want to lose my data

[Access9001]

I have an automated process that iterates through a list of maketable queries and executes them, and if there's an error, it logs it.

The problem is that if, for any reason, the query can't execute properly, I still lose my table if I try to run MakeTableQueryA but MakeTableQueryA fails. I want to be able to KEEP my table if MakeTableQueryA can't execute properly for any reason.

The other approach is to do a delete/append approach, but then if there's an error in the append process, I've still deleted my data first, and I don't know an easy way to "validate" the sql first before running it.

 

[the_net_2.0]

this doesn't make much sense. what do you mean you lose your table? the table that you're overwriting you mean? If so, that is not mentioned.

Are you running the MT queries using the same source table name and output table name?