Difference betwwen query and docmd.runSQL

  • Thread starter Thread starter ReidarT
  • Start date Start date
R

ReidarT

When running a query in Access there is a lot of networktraffic between
front-end and back-end.
When you make a docmd.runSQL with a statement is there any less network
traffic and are there any advantages / disadvantages with the two methods?
regards
reidarT
 
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
 
Back
Top