QTP always returns EOF when querying SQL statement to Access 2K3

[riechan]

Solved it. The error was with the SQL statement. Looks like QTP can't "understand" the "*" wildcard, instead, I replaced it with the "%" wildcard (which oddly, does not work when querying in Access 2003):

Code:

strSQLObjects = "SELECT * FROM " & strTblName & " WHERE Page='" & curPage & _
                            "' AND FieldName LIKE 'Add_" & strItem & "%' AND " & _
                            "(AttachedText LIKE 'Add%' OR AttachedText LIKE '%>%')"