Ado

[NOUSHAD]

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

[Lethal]

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

    RS as ADODB.Recordset
    CN as ADODB.Connection


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