General information
Category:
Database DAO/RDO/ODBC/ADO
Title:
Unable to specify LIKE Clasue with Access 97
I'm using ADO to connect to an ACcess 97 database. My queries work fine except when I try to use a LIKE clause in the SQL statement. If I cut and paste my SQL text into a query SQL view window in Access it works fine so it looks like a glitch to me. Any ideas? Thanks.
Couldn't figure out how to delete this after i entered it. the problem was that ADO demands you use a % instead of a * with the LIKE clause. How obnoxious....
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only