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

[Randall Anthony]

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/

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