resolved run-time error 91

[Aaron Young]

The Object variable or With block variable not set error could be caused by not creating an instance of the object you're referring to, i.e.

Dim oRs As ADODB.Recordset
 
    oRs.Open "SomeTable", "DSN=MYDSN;"

Would fail.

Dim oRs As New ADODB.Recordset
 
    oRs.Open "SomeTable", "DSN=MYDSN;"

Or

Dim oRs As ADODB.Recordset
 
    Set oRs = New ADODB.Recordset
 
    oRs.Open "SomeTable", "DSN=MYDSN;"

Would Work.