[AccessD] Question: How often do you run your remote table relinking code?

[Ryan W]

Yeah that's how this was but you know users can be. Seeing a spinning wheel
for 5 seconds drives them bonkers.


On Tue, Feb 15, 2022 at 1:43 PM Randall Anthony <randall.anthony at cox.net>
wrote:

> Ryan,
> Almost all our old school apps re-link upon  opening.  HTH.
>
> -----Original Message-----
> From: AccessD <accessd-bounces+randall.anthony=
> cox.net at databaseadvisors.com>
> On Behalf Of Ryan W
> Sent: Tuesday, February 15, 2022 2:31 PM
> To: Access Developers discussion and problem solving
> <accessd at databaseadvisors.com>
> Subject: [AccessD] Question: How often do you run your remote table
> relinking code?
>
> I'd been in the habit of running the relinking code right after the ODBC
> connection was established, it usually takes 8-10 seconds to delete the
> tabledefs and recreate them.
>
> I recently came across this old article
>
> https://www.microsoft.com/en-us/microsoft-365/blog/2011/04/08/power-tip-impr
> ove-the-security-of-database-connections/
> <https://www.microsoft.com/en-us/microsoft-365/blog/2011/04/08/power-tip-improve-the-security-of-database-connections/>
>
> In this article the author states the initial connection credentials are
> cached, and as long as your connection string on linked tables and
> passthrough queries match the 3 required criteria (database, server, and
> driver) you don't need to worry about storing UID and PWDs in the string
> (which I'm using mSysConf to negate anyway).
>
> So now I'm only running re-linking code when I add new tables/views to the
> FE during development.  This has made startup times a lot nicer.
>
> So my question to you all is: When do you relink remote tables? Always?
> Seldom? Never?
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> This email has been checked for viruses by Avast antivirus software.
> https://www.avast.com/antivirus
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>