What is it faster to run a SQL querie, running docmd.runSQl or execute DAO method? Thanks
J Jose Perdigao Jul 12, 2005 #1 What is it faster to run a SQL querie, running docmd.runSQl or execute DAO method? Thanks
L Larry Jul 12, 2005 #2 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
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
V Van T. Dinh Jul 13, 2005 #3 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.
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.
