Is there a way of dynamically creating full featured recordsets. For example, if I use the ADODC control, I can use Recordcount, AddItem, Update, etc. However, if I create a dynamic recordset on the fly such as

public sqlTest as string
public rstTest as New ADODB Recordset

sqlTest = "Select * from test"
rstTest.Open sqlTest, strFile, adOpenDynamic
rstTest.AddNew

This gives me very limited capabilities. The AddNew isn't available

Is it that I have an "old" version of the control or is there something else I need.

Thanking you in advance for your help