Dee-u
I open a connect (that works) from Excel via ADO.
I open the sql pasted earlier (with the %) and get the error pasted.
I open the mdb direct in Access, paste in the Sql and change the % to *
It runs.

So I thought I would pre-define a query and put in parameters to filter it. But an ADODB.Recordset doesn't have parameters...

Command does, but I would need to change a lot of code to get that working without messing up existing code.