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
