get popups/alerts when i created a table from a query

[Ms937j]

I created a table using a query. Now whenever I run the query I get
popups/alerts informing me that I am deleting the table and another informing
me that I am added the data records to the table. The query works fine. But
I can do without the popups/alerts. This database will be available for to
all users. How can I avoid these popups/alerts as well as the other users.
Thank you.

 

[John W. Vinson]

I created a table using a query. Now whenever I run the query I get
popups/alerts informing me that I am deleting the table and another informing
me that I am added the data records to the table. The query works fine. But
I can do without the popups/alerts. This database will be available for to
all users. How can I avoid these popups/alerts as well as the other users.
Thank you.

Why are you routinely running a MakeTable query? They're almost NEVER
necessary. What do you get from deleting and creating a table which you can't
get by just using a Select query as the source for a form, for a report, for
an export, etc.?

 

[mcl]

You can use a macro:

Setwarnings (turn them off)
Open your query
Setwarnings (turn them on)

Anyway, that's how I do it.

BTW, don't you hate it when people who don't know why your approach was to
use a make table query instead of just a select query answer your question
by saying just use a select query for whatever your doing?