[AccessD] Updating SQL Connections

[Jim Dettman]

 Guess it depends on how much you want to lock it down.

 I've seen apps that setup connections at startup, then flush everything at
exit just to hide things. 

Jim.

-----Original Message-----
From: AccessD On Behalf Of Stuart McLachlan
Sent: Monday, December 27, 2021 3:58 PM
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] Updating SQL Connections

Not a lot of benefit to storing it encrypted since the same details will be
available in the 
properties of any connected table once set up. 

And if they used WIndows security "TrustedConnection="Yes" instead of 
username/password, there's nothing highly sensitive there anyway :)

I've got a few application where they can use one of several BE's and store
connection 
details in a system table for switching between them,


On 27 Dec 2021 at 7:13, Jim Dettman via AccessD wrote:

> 
>  Can't be "safe from being discovered", but you'd want to encrypt it
>  anyway.
> 
> Jim.
> 
> -----Original Message-----
> From: AccessD On Behalf Of David Emerson
> Sent: Monday, December 27, 2021 12:57 AM
> To: 'Access Developers discussion and problem solving'
> <accessd at databaseadvisors.com> Subject: Re: [AccessD] Updating SQL
> Connections
> 
> Thanks Stuart - that was the better way of doing it that I was looking
> for 
> 
> -----Original Message-----
> From: AccessD
> <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On Behalf
> Of Stuart McLachlan Sent: Monday, 27 December 2021 5:00 pm To: Access
> Developers discussion and problem solving
> <accessd at databaseadvisors.com> Subject: Re: [AccessD] Updating SQL
> Connections
> 
> WHy a seprate file?   Use a usysTable in the FE that stores the
> connection string and have an Autoexec macro that checks the
> connection so startup. If it's not valid, pop up a form to maintain
> the data in the usysTable.
> 
> On 27 Dec 2021 at 14:31, David Emerson wrote:
> 
> > Hi Listers,
> > 
> > I hope you are having good holidays.
> > 
> > Has anyone come across the problem where you want to be able to
> > change SQL Connection strings on distributed databases but don´t
> > know what the string is?  Here is the situation:
> > 
> > A database application is sold to a client.  It has an Access FE and
> > an SQL BE.  I want to be able to link to the SQL BE in code without
> > having to hard code or set up the connection strings before giving
> > the application the client.  The idea is that the connection string
> > information can be stored in a place separate from the actual SQL
> > database, in a place where the client can enter the details, but at
> > the same time is safe from being discovered.
> > 
> > This excludes saving the connection string information in the SQL
> > Database because the Access FE doesn´t have the connection details
> > to be able to connect to the SQL database to get the connection
> > string details
> > 
> > One idea is to store the information in a text file (encrypted of
> > course) that the Access program can open first and check if the
> > details have been updated.  If not then the Access program asks for
> > the details, saves them to the file, then the file is used to get
> > the connection string details for connecting the Access FE to the
> > SQL backend.
> > 
> > Can anyone think of a better way of doing this, or any problems with
> > this approach?
> > 
> > Regards
> > 
> > David Emerson
> > Dalyn Software Ltd
> > Wellington, New Zealand
> > 
> > 
> > 
> > 
> > 
> > 
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> 
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com


-- 
AccessD mailing list
AccessD at databaseadvisors.com
https://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com