Confirm Table Deletion Box in Make Table Query

[Andy]

I already have the boxes unchecked in Tools>Options>Edit/Find Confirmation
area. When running make table queries, I still get a prompt to delete the
existing table.

Short of changing all of my make table queries, to a delete query, then an
append, how can I run queries without these prompts appearing.

I have a macro that runs about 40 make table queries and having to confirm
table deletion 40 times is a little annoying.

Thanks

 

[Allen Browne]

Andy, see:
Action queries: suppressing dialogs, while knowing results
at:
http://allenbrowne.com/ser-60.html

The article explains how to use Execute which avoids the confirmation
dialogs.

Personally, I prefer the Delete + Append approach, because you get to set up
the fields the way you want (e.g. with AllowZeroLength set to No, and a
primary key.)

 

[Andy]

Yes delete and append would appear to be better - reflective wisdom...

Haven't got time to re-write 40 make table queries and convert to 80 delete
and appends!!!