opening multiple databases

[mjs06]

The main menu of my database has buttons to open other databases. The login window always opens when another database is clicked even though the login name and password are the same for all the databases. Is there a way to keep from having the second, third, etc login windows always open which require reentering username and password?

Thanks.

mjs06

[MMcCarthy]

Normally database security is tied to the database. So the simple answer to your question is I'm not aware of any way of doing this.

One solution would be to change your login security to be based on the NT User Name of the current user (not using a login and password). The database would check this user against a list (table) of authorised users.

Have a look at this tutorial.

Function to return username of current user