View Single Post
  #21  
Old February 3rd, 2008, 08:42 PM posted to microsoft.public.access,microsoft.public.dotnet.framework.adonet,microsoft.public.dotnet.languages.vb
Arvin Meyer [MVP]
external usenet poster
 
Posts: 4,231
Default Opening Access db via DAO in vb.net

"Norman Yuan" schreef in bericht
...
With all other replies being post, I am just wondering: why on the earth
do you need to use DAO in .NET?


"Michel Posseth [MCP]" wrote in message
...
Well after thoroughly thinking about this question , the answer seems

You don`t

:-)

Or maybe we are both missing something here


What you're missing is that it's not .NET that is using DAO as much as the
JET engine. And you can use ADO very successfully with the JET engine, but
is will be slower. Typically, that speed in a well designed database with a
well designed query is of little concern, becuase it is not likely that you
will be searching through more than 100K rows in JET, so a 1/2 second
doesn't mean much. But if you are looping through a recordset with 100K of
rows, it can mean a significant difference.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com