Having spent a few hours on this same problem, I thought it would be good to post the fix for it. :eek:
The error MAY be nothing to do with the SQL but with the call to "openRecordSet".
"openRecordSet" exists in the DAO and the ADO libraries and each requires different parameters. Code...