When, in general, is it best to use DAOs as opposed to data controls? We are building VB clients for Access and MS SQL Server.
If you plan it right, you can use a combination of data controls AND theDAO objects. Under Visual Basic 4.0 and above, you can set the Recordsetproperty of the data control to a recordset you have created using theDAOs. For instance, you may want to fill a drop-down list from a database. Simply set the recordset to one retrieved from the current database. Ingeneral, DAO gives you a lot more control over how your application works,but the data control still has a lot of power hidden in it.