DAO or ADO – what’s the best to use when working with Access?
Q: Scott Berry writes: “When should I use ADO and when should I use DAO? I have always used DAO since Access 97, but a lot of guys at work use ADO because it is the ‘new standard’.”
A: I haven’t yet seen any reason to use ADO when working within Access (or for that matter, when writing Automation code working with other Office applications). It is useful when working with other (non-Microsoft) applications. DAO was created specifically to work with Access data, so it has lots of features that work just right with Access; ADO is much more awkward to work with (in my opinion, anyway), so I recommend sticking with DAO for working with Access data in Access and Office programming in general.
