Can anyone give their views on the pros and cons for using DAO versus ADO when accessing MS Access databases from Navision. The prevailing view seems to be ADO is best, does anyone know why?
Not knowing the exact arguements for either DAO or ADO, I do know that ADO is the newer technology and therefore should be the better of the two. Reading the following article it looks like ADO is better in the respect that it is a model for connecting to different back-end engines. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnado/html/msdn_adovb.asp Hope this helps.
DAO is the old way of doing things, it is since VB4 Programatically, in DAO you work with Databases and Recordsets. In ADO you work with Connections, Commands and Recordsets. ADO is faster and dynamic then DAO ADO can be used with other type of database, non-access database like outlook/emails