100% right. I've just got around to having a play, and when setting up the Access link, you have the option of saving the password, which embeds the access credentials in the link properties. There does not appear to be any option of modifying an existing link to do this. So the answer was in Access.

This gives me a solution that will work perfectly, and solves another problem at the same time. Thanks for the pointer.

Andrew