turning off action query confirmation dialogs?

[Howard]

I have a make table query called via code that erases and remakes a
table prior to using it as the basis for a report. The call is within a
'set warnings off' block.

I get two confirmation messages "the existing table will be deleted...."
and "You are about to append n rows to a new table..."

Under tools|options|Edit/Find I've unchecked confirm action queries
which prevented the second message but I still get the first.

Any ideas how to stop it?

Howard

 

[John W. Vinson]

I have a make table query called via code that erases and remakes a
table prior to using it as the basis for a report.

There are at least three ways of doing this. Delteing and creating a new table
is THE WORST of the three!

Slightly better would be to run a Delete Query to *empty* the table, followed
by an Append query to fill it. This saves the overhead of removing all
references to the table from the Systems tables, creating new references to a
table in the Systems tables, etc. etc.

Better yet would be to base your report on a Select Query (the same select
query that you're making into a MakeTable query).

It may be that you're assuming that you need a new Table in order to create a
report. That assumption is reasonable if you come from (say) a Paradox or
dBase programming background, but it's *incorrect*.

You can use the database Execute method to run action queries without warnings
but... don't. You're just bloating your database and wasting time and effort!