7.2. Referring to ADO Objects

When you refer to ADO objects, you do so in the same way you would using DAO, but the difference is that ADO does not have a native connection like DAO.

Recall that in DAO you can use the DBEngine(0)(0) object or the CurrentDb() function to return a reference to the current database. ADO does not have a current database. In fact, it doesn't know anything about dataset; it only knows about data sources through a provider. Therefore, in ADO, you must always implement a connection to an external data store through a provider.

7.2.1. Default Collection Items

As you may recall from Chapter 6, an object's parent collection can have a default member that you can refer to. The following table lists the default members for those ADO objects that have them.