i currently use the connection string below when i connect to a sql database from the ms access db. The connection string is used for passthrough queries and recordsets. it works fine
connstring = "Provider=SQLOLEDB;DRIVER=SQL Server;SERVER=" & serverip & ";UID=" & usernamewrite & ";PWD=" & passwordwrite & ";DATABASE=DBName"
I am not being asked to encrypt the connection I am making the sql server. any advise on how to go about doing that?