Yes; if you're running the query from a Macro or from VBA code, put a
line to set SetWarnings to False before running the query. Be sure to
put Setwarnings back to True afterward, or you'll turn off ALL warning
messages for the rest of the Access session.