Search results

I guess it's just another weird quirk in the world of Microsoft. Thanks for the quick help, pbaldy!

Changing the asterisks to percent signs in the VB.Net application solved the problem, but I'm really baffled by that. The MS Access documentation specifies the asterisk as the wildcard character for multiple characters, and does not mention the percent sign at all, and it is the Access database...

Here's the operative code from the VB.Net application. It works as expected when there is no WHERE clause in the SQL code: 'ConnectionString string variable is pre-loaded with connection string for Access database Using cn As New OleDb.OleDbConnection(ConnectionString)...

I'm using the SQL shown below to query a simple Access database. When I start a new query in that database, paste the SQL code into SQL view and then run the query, it performs as expected, i.e., it returns all the records where the string "red" appears anywhere in any of the three columns...