Using "like" query from and external link to Access

[akadas]

Hi,

I am connecting into an Access 2007 database that I set up, and one of my queries uses the "like" keyword. The query runs fine within access but if I connect to it externally (say through ADO or something setting it up in my window's ODBC list) the same query returns nothing.

I checked the query without using wildcards in the "like" quote (such as *)and then the query worked as if I was using an "=" clause. Of course I do not want that.

Has anyone faced this issue before?

Thanks

 

[Douglas J Steele]

If you're using ADO, the wildcard characters are % and _, as opposed to *
and ?. This is also the case if the client is set for ANSI 92 compliance.


wrote in message

Hi,

I am connecting into an Access 2007 database that I set up, and one of my
queries uses the "like" keyword. The query runs fine within access but if I
connect to it externally (say through ADO or something setting it up in my
window's ODBC list) the same query returns nothing.

I checked the query without using wildcards in the "like" quote (such as *)
and then the query worked as if I was using an "=" clause. Of course I do
not want that.

Has anyone faced this issue before?

Thanks