I am trying to get rid of a password that comes up every I use the DB. It has linked tables and the password is needed to connect to the DB with the tables. I have the following code.

Dim conn As ADODB.Connection
Dim rs As ADODB.Recordset
Dim sql As String
Set conn = New ADODB.Connection






conn.ConnectionString = "DSN=V6-ODBC;HOST=servername;DB=production;UID=username;PW D=password;PORT=portnumber;DefaultIsolationLevel=R EAD UNCOMMITTED"
conn.Open conn.ConnectionString