The wildcard character of the like in Access cannot be used in%.

Transfer from http://www.knowsky.com/339881.html

The wildcard usage for like in Access is:
“?” Represents any single character; "*" means 0 or more characters; "#" means any number
So it should be:
SELECT * from DatabaseName where fieldname like ' *xx* '

Originally in SQL SERVER is a percent, in access is the * * number, no wonder you can not find data!

But if in the VS2005 TableAdapter again with the percent, with * not!!!

————————————————————————————————————————————————————————————

Tested: Using the query functionality of the Office Access database, the wildcard character of the query statement requires *, not%, as described above.

However, in the VS program, although the queried database is Access data, the query SQL statement should use% instead of *, and the program should use standard SQL syntax, otherwise it will not be queried normally.

The syntax of the query function for access software differs from the standard syntax.

The wildcard character of the like in Access cannot be used in%.