Access and ODBC

[Agnieszka]

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

[Clunietp]

If you have the same username/password, can you specify them in your connection string or have the user input them into a variable (via an inputbox) and append that string to the connection string?

[JHausmann]

Create a database that's comprised of links to the 17 tables, then open that once.

[This message has been edited by JHausmann (edited 10-22-1999).]