Wild card characters not accepted

[Paul Cram]

I am trying to open an ADO recordset which calls a query
with a criteria of "like 'app*'" This returns am empty
recordset although the query itself generates records. I
have tried passing a sql string but get an error message.
The knowledge base indicates this was a problem with 2.1
but was fixed with a service pack. I am using ADO 2.8.

 

[Douglas J. Steele]

The wildcard character in ADO is %, not *.

 

[Paul Cram]

Douglas

Thanks for your reply. I have tried a % sign. In the
access query this doesn't return any records. If I try to
use a SQL string in VBA I get an error message "Join
expression not supported" The SQL returns a result if I
change to a definite criteria rather than one with a
wildcard.

Paul

 

[Paul Cram]

Hi

I have retried it and although the query does not return
any records the recordset does get them. So no problem
now. Thanks again.

Paul