[AccessD] DoCmd.RunSQL or CurrentDb.Execute?

Developer Developer at UltraDNT.com
Tue Jan 6 16:42:40 CST 2004


Currentdb.execute will bypass the warnings if they are on,
Docmd will still have the warnings.
Currentdb has been faster for me, but I havent benchmarked anything
specific. 

Hth
Steve


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Fenton
Sent: Tuesday, January 06, 2004 5:22 PM
To: accessd at databaseadvisors.com
Subject: [AccessD] DoCmd.RunSQL or CurrentDb.Execute?



Quick question...
Which is better to use?
Assuming an SQL string in a variable called strSQL
Then...

DoCmd.RunSQL strSQL
Or
CurrentDb.Execute strSQL

They both have the same outcome; I was just wondering whether one was
maybe faster or something?

Cheers 
David
Brisbane
Australia


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list