main objects of ADO

A

Alex White MCDBA MCSE

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.
 
Top