I have a string... mySourceConn.Open "Driver = Teradata; DBCName = tdprod1; Database = " & DB_Source & "; uid = " & UID & "; pwd = " & Pwd in which I would like to pass the encrypted password into the "Pwd" field as the regular password.