Nearly 5 years on, and this is still the best - and only - answer I have been able to find on-line for this VERY vexing problem. Access 2003 SP3 is still generating incorrect syntax for Append queries targeting password-protected databases. Note that in Jon K's solution, Access will...