How about using ADODB?
With ADODB, you can set the user name and password, then call a recordset. I have not tried to connect an ADODB recordset to a Data Control, but it should be possible.
Another option is to create an ODBC link. I have used this several times. When I start my project, I...