I spent (too many) hours today trying to figure out why I couldn’t get a query to run through ADODB from an HTA I’m working on. The query pulls from a linked table which links to a tab-delimited text file, and the query had a WHERE condition as such:
WHERE field1 LIKE "00*"
Apparently, I wasn’t doing anything wrong, but the query keep returning empty. Only when I changed the WHERE clause to
WHERE field6 Is Not Null
did I get the expected results. I don’t know what to think of that, but it’s a good thing to remember.
I was using ADODB to run a query from MS Access, btw.