docmd.runSQL Vs DB.execute

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

What is it faster to run a SQL querie, running docmd.runSQl or execute DAO
method?
Thanks
 
Generally, DAO executes faster than just about anything else. Of course,
depending on what's being returned from your code, you might not notice a big
difference.

Larry Kraus MCP
 
db.Execute may be marginally faster but I doubt it is an observable
difference.

The *major* difference is that Execute returns trappable JET error if you
want to use error-trapping.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

db.Execute vs DoCmd.RunSQL 4
Seeking Advice 7
DoCmd.RunSQL who could check my sql? 8
Performance Issue 3
Alter Back-End Table from Front-End 5
Use a Query's Result inside an UPDATE Statement (VBA) 2
Execute SQL Stored Proc from Access 1
modifiy field type by vba 6

Back
Top