[AccessD] Which Is Faster - DAO or db.Execute?

Susan Harkins ssharkins at gmail.com
Wed Oct 29 09:24:11 CDT 2008


A lot going on there without a consensus. I thought the original question 
was comparing the library edits to a SQL statement -- I might have goofed 
there. Did you read the statements at the end -- very interesting.

I think DAO and ADO solutions are definitely more versatile than straight 
SQL -- you upsize with ADO/DAO, you don't have much work -- most of your 
code's going to work with Jet or SS, whereas your straight SQL's going to 
need some work.

Susan H.

> Susan
>
> You might find this useful
>
> http://www.tech-archive.net/Archive/Access/microsoft.public.access.modulesdaovba/2005-03/1330.html
>
> Martin




More information about the AccessD mailing list