Hiya,
You don't specify how the query is being run - via a macro or a VB module.
If it's a macro, you can setwarnings to false, run the query and then setwarnings to True again (essential step!).
If it's via a VB module, something like this will do:
DoCmd.SetWarnings False
DoCmd.OpenQuery...