The Data control is simple to use but doesn't offer extremely fast database access. Although today's computers run quickly, you'll notice speed degradation when you use the Data control in large database tables, especially ODBC-based databases.
When you use DAO, you must write more program code than you have to write with the Data control. As you saw in the first topic section, you can program the Data control primarily through setting property values. Although you can write code that accesses various Data control methods, straightforward database access is less involved with the Data control.
The DAO lets you control the data access in a much stricter way than with the Data control. The ease of the Data control reflects its inability to be flexible. Also, the overhead of the Data control doesn't burden DAO-based programs. DAO uses the recordset concept for most of its operations, and you can create a recordset variable just as you can create other kinds of object variables in Visual Basic.