Let's take a quick look at the properties of an ADO data control and a standard data control. Bring up the property window for the ADODC data control:
Notice that with the ADO data control, we have the connection string that tells the control which OLE DB provider to use. This string contains the fully qualified name and location of the database to open. And then the .
property tells the control which table to open - in our case Publishers. And since we want to open a table, instead of a dynaset from a join, the .RecordSource
of adCmdTable is selected. Take another look at the ConnectionString - notice that the OLEDB 3.51 provider is listed. CommandType