Win Surprise Gifts!!!
Top 5 Contributors of the Month
Post New Question
Subscribe to Forum
difference between ADO and DAO programming?
February 20, 2010
programming difference between ADO and DAO programming?
Posted Date: February 20, 2010 Points: 5
To get the difference between ADO and DAO you can refer this post.
Posted Date: February 22, 2010 Points: 5
Please Check my answer if you help....
Posted Date: December 07, 2010 Points: 5
I think the main difference is about the recordset type you used. If you use
a FIREHOSE recordset, with ADO, you have the minimal recordset possible,
having fetched just the first record (from the SELECT statement), and which
will wait for you to explicitly make a move next record to fetch the next
record, while with DAO, you may have, by default, a recordset which pump the
whole table (all records, or at least, a set of bookmarks). Note that a
firehose recordset is a ReadOnly ForwardOnly recordset. You can also try not
force waiting the end of execution of a parallel thread of execution by not
asking, as example, for a MoveLast: generally, Access will open the
recordset and fill it on a parallel thread of execution, so your VBA thread
of execution may not have to wait that the recordset is fully initialized.
You can see it in action when you open a long query: the first page is
displayed quite fast, but the "y" value in the displayed label "x record of
y" may take much more time to appear.
Access, Excel, VBA, DAO and ADO all work based on COM technology.
ADO can use tables created by DAO without problem. Can also use tables
create in Oracle, by whatever tool you used to speak to Oracle in order to
create the tables. The tool used to create the tables is irrelevant, just
the tables themselves matter.
To post reply
Related Questions Related Questions
difference between an EXE and a DLL
Difference Between console application and windows application?
Difference between Web Garden and Web Farm
Difference Between Response.Write and Response.Output.Write?
Difference between Language and package
Difference between JDK and SDK
Difference Between SDK and IDE
What is the difference between Get and Post method?
What's the difference between Response.Write() andResponse.Output.Write()?
Difference between Factory, Abstract Factory and Inheritance
Latest Forum Questions From The Same Category
Window Service C#.net not working properly
C# Onvif IP Camera Viewer NuGet package
Land Registry Business Gateway Webservice - reference the returned XMLDocument
Technology to be used for Finance Application
problem instal net framwork 4
I am looking for Dotnet developer opening in Middle level company.
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more
Quick Links For Forum Categories:
Hall of Fame
Terms of Service
Tell A Friend