DSN-less connection in Access

Once again use it recently, easy, you don't need to create DSN in order to link to MS SQL Server. Nice article from Doug Steele. Basic idea that you construct connection string as:

ODBC;DRIVER={sql server};DATABASE=Northwind;SERVER=MyServer;Trusted_Connection=Yes;