Martin Reid
mwp.reid at qub.ac.uk
Wed Oct 29 09:08:37 CDT 2008
Susan You might find this useful http://www.tech-archive.net/Archive/Access/microsoft.public.access.modulesdaovba/2005-03/1330.html Martin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: 29 October 2008 14:00 To: Access Developers discussion and problem solving Subject: Re: [AccessD] Which Is Faster - DAO or db.Execute? > > 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. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com