Max Wanadoo
max.wanadoo at gmail.com
Thu Oct 30 07:31:58 CDT 2008
So, how does what I posted differ from these two postings below? I think my posting was entirely within the bounds of the questions being put back and forth between different people. Sorry if I got that wrong. I will drop out of the conversation Thanks Max > > Both are DAO, but what he is asking is if db.Execute with a SQL > statement is faster then opening up a record set, finding the record, > and then doing an .Edit/.Update. >======Yes, I realize they're both DAO, I just thought I'd clarify. My claim is that SQL is faster -- it speaks directly to the engine -- it has to be >faster. >SUsan H. > -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: 30 October 2008 08:21 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Which Is Faster - DAO or db.Execute? Hi Max I know, but the title was created by Rocky and referred to his task which was quite different from the task you describe, thus some confusion could easily arise. /gustav >>> max.wanadoo at gmail.com 30-10-2008 08:53 >>> Hi Gustav, I was responding to the title of these messages, ie: "Which Is Faster - DAO or db.Execute?" Thanks Max -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock Sent: 30 October 2008 06:58 To: accessd at databaseadvisors.com Subject: Re: [AccessD] Which Is Faster - DAO or db.Execute? Hi Max No, but that was not the task of Rocky. /gustav >>> max.wanadoo at gmail.com 30-10-2008 00:30 >>> Ah yes, but what about... -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com