Reidar,

As far as the bulk of network traffic generated by a query, it makes no
difference how you run it, but when you run a query from VBA, we always
recommend using db.Execute instead of DoCmd.RunSQL.

I don't know of any performance differences, however, the Execute method has
a dbFailOnError argument, that will generate an error if the query fails for
any reason. You can trap this error. The Execute method also has several
other arguments that can prove rather handy. See Access Help for more
information.

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
---------------------------