How to set up search form using WILDCARDS in data access page?

[ebb]

I am designing in Access2003. A simple parameter query using LIKE and "*"
does not work. I realize a different engine reads the query and doesn't read
the wildcards. What can I do? Different ANSI code?

 

[Tim Ferguson]

I am designing in Access2003. A simple parameter query using LIKE and
"*" does not work. I

Depends on the library you are using. ADODB uses standard % and _ for
wildcards, while DAO still uses DOSalike * and ?

Hope that helps


Tim F