I pass a simple select statement to the open method of an ADO recordset and it fails to return any records. The SQL Statement is:
SELECT * FROM CLIENT
WHERE LAST_NAME LIKE "SMI*"
If I paste this statement into the SQL design window in Access 97, it returns the appropriate # of recs. All other SQL statement types that I have used that did not include "LIKE" in the Whereclause return the appropriate # of recs.