[AccessD] Changing DSN Connection strings

Paul Wolstenholme Paul.W at industrialcontrol.co.nz
Wed Dec 8 13:49:11 CST 2021


I also endorse the use of DSNless connection strings (except maybe when you
first inherit an existing project).  The answer I supplied (detailing the
saving of the password in the front end) is applicable to both DSNless
connection strings and connection strings that use DSNs.

Paul Wolstenholme


On Wed, 8 Dec 2021 at 21:26, Stuart McLachlan <stuart at lexacorp.com.pg>
wrote:

> Me too. I gave up messing with DSNs on user's computers years ago. It was
> always a PITA.
> .
> Build the connection string(s) into a VBA module and you know it will
> always be correct.
>
>
> On 8 Dec 2021 at 7:25, Gustav Brock via AccessD wrote:
>
> > Hi David
> >
> > We use DSN-less connections, which I've found are easier to control:
> >
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list