MS Access 2010 TLS 1.2 Data link error

Question

Hi,

We have a legacy application in MK Access 2010 and recently we have upgraded our TLS policy

The connection properties are defined in data link properties 

File > Info > Server > SQL server name and database

I need to update the connection string.... where is this information stored in MS Access? anyone any idea?

Error details because of TLS 1.2 upgrade

I want to change the connection string to this

 "provider=SQL Server Native Client 11.0;integrated security = sspi;data source=" & ServerName & ";initial catalog=" & DatabaseName

Thanks for the help...

Answer 1

The following was written for A2007 but the code should apply in your situation. 

https://docs.microsoft.com/en-us/office/troubleshoot/access/change-the-connection-of-project

That being said, I am doubtful you'll be able to use SQL Server Native Client 11 with an Access ADP.  Please post here if you have any success.

-Bruce