The DAO and ADO Data Control Properties Compared

Let' have a look back at the DAO data control's properties by way of comparison with ADO:

The standard DAO data control shown here uses the 

.DatabaseName
property to reference the fully qualified name and location of the database. The 
.Connect
 property tells the control to use the installable ISAM file for connecting with Access (remember that there are options here for Paradox. FoxPro, etc.) And the 
.RecordSource
property is the same. We selected Publishers.  Notice that the 
.RecordsetType
 is 0 - Table. So we include the exact same information to the control, but it is located in different properties. But the ADO data control can do so much more with the same information.

© 1998 by Wrox Press. All rights reserved.