sql and keyword search

[Negative0]

In your Like call you need to use wildcards.

Such as "txt1 like '*" & textbox & "*'"

[csingeu]

Actually I'm also facing this problem...
and but my problem is ...
i already included the wildcards

SQLString = "SELECT * FROM Main WHERE Name LIKE ('*John*')"

but it still cannot work with ado dc ..
btw, I using access2000 and the ado dc is bound to a datagrid.

[Richyrich]

Not an expert with ADO however I do beleive that the wildcard character is a '%' not a '*' .

[JHausmann]

The wildcard depends on if the the DBMS is ANSI standard...