[AccessD] Changing DSN Connection strings

[David Emerson]

Thanks Everyone.  I came to the same conclusion.  None of my own
applications have ever used DSN connections.  This is a project that I have
just inherited, and I am working through their list of problems.  Most of
them relate to the connection method.  I will be converting it to DNS-Less
connection.

Regards

David



-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On
Behalf Of Paul Wolstenholme
Sent: Thursday, 9 December 2021 8:49 am
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Changing DSN Connection strings

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: