I am trying to push tables of data to multiple databases using a master database. All of the child databases have passwords on them which is fine as I know them all. I am able to create the append query, but when I run the query I get an "invalid password" message. Does anyone know how to get around this? I'd much rather push data from this one database instead of pulling it from 10+ other databases that need this data.
Thanks in advance
Thanks in advance