I´m working on an access2000-database, which uses tables from a sql-
server via an odbc-data source (dsn). So far so good...
When you start the database and use one of the tables for the first time,
appears the sql server-login, where you have to enter username and
password. After that you don´t need to enter it again until closing the
What I´m looking for is a possibility, to avoid the login-window (on
the SQL server I have no influence) and to perform the login with vba.
The reason is, that I don´t want every user to know username and
password for the sql server. But even with this solution, the sql server
login should be performed only once.