Thanks Clay - thats a great help, I've managed to solve this now by getting access to manage the passwords. When you are adding a linked table in Access there is a small option in the bottom right hand corner of the wizard to save the password (not very obvious at all). That does the trick, Infopath doesnt have to do anything at ...