Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Replication / August 2005

Tip: Looking for answers? Try searching our database.

DAO vs ADO

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Cheri - 10 Aug 2005 20:52 GMT
All of the code samples I have seen are for DAO...can ADO be used for
the autosync?  Example command button.
David W. Fenton - 11 Aug 2005 19:13 GMT
> All of the code samples I have seen are for DAO...can ADO be used
> for the autosync?  Example command button.

ADO is not a Jet-specific access method -- it is an abstraction
layere, like ODBC, intended to function as a common interface to
multiple data storage systems, each with its own specific
functionality. That means it provides all functions that are
supported by almost all db engines, but doesn't necessary support
functionality that is supported by only a few platforms (or
supported in very different fashions in different db engines, as is
the case with replication).

When Microsoft went down the ADO garden path, stupidly recommending
it as a replacement for DAO with Jet data (something they've since
reversed), they were smart enough to realize they needed to provide
some support for Jet replication that was similar to ADO in its
architecture (one of the advantages of ADO against Jet over DAO is
that it's thread safe), and so they created JRO.

JRO should have together all the Jet replication functionality into
a single library, making the use of DAO + TSI Synchronizer obsolute.

But it didn't. See:

 What does DAO have that ADO/ADOx/JRO do not have
    (and might never have!)
 http://trigeminal.com/usenet/usenet025.asp

So, like with all Jet operations, DAO is still the best method for
working with Jet data.

And that's why most of the code examples (with the exception of the
Microsoft Knowledge Base) are in DAO.

Signature

David W. Fenton                        http://www.bway.net/~dfenton
dfenton at bway dot net                http://www.bway.net/~dfassoc

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.