I just had the same problem - Access does not properly fill in the "Dest Connect Str" in the query properties. You need to add more parameters along with the "PWD". I used this for my query:
MS Access;PWD=testing;DATABASE=C:\Users\YourFilePath\YourAccessDatabaseFile.accdb
Hope this helps...