Ado

HI,
I could use ADO datacontrol in my prgramme preveiously, but now i could use only dataenvironmet and ADODB by using code not ADO datacontrol the error message is 'object variable or with block variable not set'
what will be the wrong

Your missing a Set statement. You must instantiate your object variables, not just declare them. For example:

Code:

---

    RS as ADODB.Recordset
    CN as ADODB.Connection


    '// Instantiate objects
    Set RS = New ADODB.Recordset
    Set CN = New ADODB.Recordset

---