UPDATE

I now do and don't know what is causing the above issue. Basically the package runs ok providing the tables the query is based upon are in the same Access database as the query itself. If they are attached tables, then the problem above appears.