You can define your ADO-Connection with the OpenConnection-Method from the CurrentProject-Object.
see
I found little information about this, but you can use this method to set the database(connection) and the user + password.
just use:
[tt]CurrentProject.OpenConnection connectionstring, user, password[/tt]
for the connectionstring just use a configured adp, and copy the string from the result of
[tt]debug.print CurrentProject.Connection[/tt]
(as you can see this string also includes the databasename, perhaps you may want to change it for some reason, here you can do it...)
user is a user on the SQL-Server,
pw is the password for the user.
Use this method to built a self-made user-login or to set the connection in a startup-form.
You can check for connection with
[tt]CurrentProject.IsConnected [/tt]
hope this helps,
greetings from Germany,
Jens