I'm using access to create some reports and I'm using 17 diferent tables from 17 different databases, and my question is.. everytime I run macro access is asking me 17 times for username and passw...how can I pass username and passw, so it won't ask me everytime i'm trying to run a macro

Thanks