Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Unable to specify LIKE Clasue with Access 97
Message
From
23/07/2002 00:00:29
Jason Dalio
Northern Interior Regional Health Board
Prince George, British Columbia, Canada
 
 
To
All
General information
Forum:
Visual Basic
Category:
Database DAO/RDO/ODBC/ADO
Title:
Unable to specify LIKE Clasue with Access 97
Miscellaneous
Thread ID:
00681464
Message ID:
00681464
Views:
41
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
Map
View

Click here to load this message in the networking platform