Confirm Table Deletion Box in Make Table Query

A

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

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...8ef7b76f11&dg=microsoft.public.access.queries
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Crosstab Query to Existing Table 0
Confirm Table Deletion Box in Make Table Query 2
Black Lines appearing over table borders 0
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Setting column width in a table with a macro is not working 0
Format column widths from one table to a separate table on same page 1
Create a chart from a table in word thats dynamic 0
Dealing with a Pivot Table (when I don't want to) 0

Top