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