Re: [MSAccessProfessionals] Odbc connection no saving password on linked tables

There's a checkbox you can check while linking the tables that saves the password.

If you want to go DSNless, there are several methods.  I adapted this:

https://support.microsoft.com/en-us/kb/892490

Doug's code is also very popular:

http://www.accessmvp.com/DJSteele/DSNLessLinks.html

Paul

------ Original Message ------

From: "anzus101" <anzus101@gmail.com>

To: MSAccessProfessionals@groups.io

Sent: 11/8/2021 1:14:34 PM

Subject: [MSAccessProfessionals] Odbc connection no saving password on linked tables

Everytime, I need to type a password on every linked table I used in Sql. Could you share a ready to copy and paste vba that connects to mssql on a dnsless way?

Thanks