ADO hase three componnents for Connections and Execution against a 

database, the Command, Connection and Recordset objects.  I would like to 

find out the fastest (returning data not developing) way for execution for 

the following scenerios;



1.  A select from the database to populate a list box (10 to 50 rows max).

2.  An update of a small number of rows (1-10).

3.  A select from the database using parameters for a stored procedure.

4.  A delete to the database.



I know I can use the recordset object to do my connection and process my 

statement but is this more effective/faster than using the connection, 

command and recordset objects for their implied purposes to do the same 

thing?  Is their no difference?



Also is it possible to destroy the connection object used to get data from 

the database and put it into a recordset object and be able to continue to 

work with the recordset object?



Thanks for your help.



Dave