Best:
dbEngine(0)(0).Execute "Query1", dbFailOnError
Also possible:
DoCmd.RunSql "Query1"

Signature
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>I should know this but am drawing a complete blank!!!
>
> I have an Append query.
>
> How do I run it from code?