Duplicate Security warnings

[kjahn]

Since applying the Office SP2, it seems that I get 2 security dialog boxes
when running an action query.
This only happens if I run the action query from the db window. The first
dialog says: "You are about to run an append query that will modify data in
your table..."
If I say yes, then I get the second dialog which says: You are about to
append 170 row(s).
I only get both messages if I don't open the action query in design view
first. If I do this, I only get the second dialog box.

Is it possible to get rid of the first dialog warning without getting the
second without having to open the query in design view First. I want to keep
the second warning just get rid of the first. This only happens to me, since
noone else in the db runs the action queries from the db window.

 

[freakazeud]

Hi,
run the query with the following syntax:

CurrentDb.Execute "yourqueryname", dbFailOnError

It will not show those warnings, it runs faster then DoCmd.Run Sql, it will
prevent bloat and it will show errors if they occure while running which
SetWarnings False dosn't!
HTH
Good luck

 

[kjahn]

But I'm trying to run the queries from the db window.
i.e. Double click them

 

[freakazeud]

Are your users running them from their, too?
You should create a user interface (forms) for them so they can run whatever
they need to from there! The db windows should be hidden.
HTH
Good luck

 

[kjahn]

I am the only one that sees the db window. I'm just trying to make my life
easier. I just take the shortcut of running the querries from the db window
when I'm trying to debug something. It's just a pain to see the extra
message everytime, if I don't first open the action queries into design view.

 

[freakazeud]

You won't be able to disable the warning then as they are supposed to appear.
only methods are to turn warnings off before query execution or to execute
the query with the earlier mentioned command.
Either way requires a macro or VBA.