Access 2003 switches to Windows Authentication instead of SQL Authentication
I am trying to setup DSN-less links to a MS-SQL server using SQL authentication. I am able to create the table links and they work during the session that I create them, but if I close and re-open the database they fail saying that "Login failed for user machine\username" - indicating that it tried to connect using Windows authentication.
I could have swore I've had this work before, but I've been unable to get it to work in this case.
Here is the code I'm using to create the links.