DSN - DSNLess Connection Help

I am using MS Access as a frontend to SQL Server tables on 2 differnt machines. One machine uses Windows Authentication so DSN connections have been no problem. The other machine is using SQL Authentication and I am having issues with DSN connections to these tables because of the User ID and password required by SQL. I use the SQLConfigDataSource function for creating the DSN but the UID an PWD parameters do not work for the SQL authentication connections. I have found that apparently these parameters are not supported by the API.

At this point I have tried to figure out how to do this through a DSNless connection but am new to ADO and have really no idea how to establish the connection let alone how to link the tables through the connection. I am much more comfortable with the DSN approach but at this point I am stuck.

For the sake of arguement lets say the following is the environment.

Server1 (Windows Authentication) has the following tables
Table1
Table2

Server2 (SQL Authentication UID=user PWD=password) has the following tables
Table3
Table4

With this environment how do I establish DSNless connections to both servers and then make Access think that all four tables are linked tables. I want the to be treated as linked so that I can still use the design view as well as view data in the tables in Access without need to use the SQL Enterprise manager for testing purposes.

Any help/guidance would be greatly appreciated. Also if this is not the appropriate venue for this question I am sorry.