I am receiving

Run time error '-2147467259(80004005)'
Method 'Open' of object '_Recordset' failed.

error when I try this

strSQL = "Select Distinct lname from names order by lname"
rs.Open strSQL, DbConnection, adOpenForwardOnly, adLockReadOnly

I open DbConnection (It's working) and it just crashes for no reason (It seems that way.)

If I try the same thing with DAO it's working.

Please help.

Leo Koach