I'm using either Remote Data Object or Remote Data Control and I still have problems with this.
This SQL statement doesn't return me any results, or errors:
SELECT fname FROM AUTHOR WHERE fname LIKE 'bl*';

fname is in access 97 db, set to text, required no, lenght 25

If I use this SQL in Access, it will return me 2 results, what is perfect.

Does anybody have any ideas, why VB would return me 0 results ?

I tried using Remote Data Control or creating a RDOEnvironment & in it, connection, query & resultset, but still it's like banging it in the wall.


All help or suggestions are highly appriciated.

Thank you in advance.


Alesh