Hi,
adodb.recordset and adodb.connection are the 2 main ones there are others
like adodb.command but not used as often.
simple put
dim adoCn as new adodb.connection
dim adoTable as new adodb.recordset
adoCn = open a connection to the database
adoTable open a specific result set/recordset etc.
within access 2000 or greater when using adp style projects you don't need
to declare the connection object as the currentproject.connection object
does that job for you so you only need to declare the recordset object.
hope that answers your question.