What you want is a DSN-less connection. You should be able to find information on Microsoft.com. But the easiest way I have found to create one is to use a DSN to connect to the database. Then design the link that was created and view the properties of the Link. It will give you a warning that says you cannot make changes, but if you look at the Properties and the Description it will show you the connection string (which is the key). I don't remember, but I think if you use a DSN with User and Password it will show you the variable names to use. If not then I would try USER and PWD as typical variable names. You can use a macro to help you get the syntax correct.