Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ADO vs. DAO
- Thread starter tmorita
- Start date
DAO is used specifically for the JET Engine behind Access. The DAO library for Access 97 and 2000 differs because each version has a different version of JET. ADO code is not limited to the Jet Engine. If you anticipate upsizing your application to SQL Server or some other server backend, it is best to design your code with ADO from the onset. Otherwise, you will need to go back and rewrite all code that manipulates the backend data. ADO looks intimidating at first, but in some ways is simplier that DAO. In other ways, some of the things you've come to expect in DAO are not as straight forward in ADO. Either way, it is worth the effort to acquaint yourself with it. Try a third party book. The MS help files do not always tell you why things need to be in a certain format. "Databases That Work The Way You Do!"
- Status
Similar threads
- Locked
- Helpful tip
- Locked
- Question