Some notes on using SQL Server connection strings both using the default ODBC client drivers and also the native SQL Server driver.
Juan Soto of Access Experts explains connection strings from MS Access to SQL Server
Additionally I am hearing that it is better to use the SQL Server Native Client ODBC driver than the default SQL Server driver as a recent security update on SQL Server has caused issue with some applications using the default SQL driver.