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

[Jim Dettman]

 I only run mine when a user changes companies or the data environment
changes (i.e. production vs dev).

 When a user simply changes companies, I even cut that down by only
relinking tables that change with a company change (some tables are in a
'system' database that are the same for all companies).

  The setup I have allows for multiple companies and multiple data
environments. I can for example have company 1 and 2 under production, and
then have company 1 in production, dev1, dev2, etc.  Within those, each
table can point to its own server/database for each table.  I use an
external table to keep track of all that.   By using an external table, I
can use queries to create new companies and/or environments. 

 I have one procedure that fills the table based on what's already in the
DB, which I call when I make changes.  Then another for resetting all the
links when needed based on the table.

  Nothing super exciting and I suspect probably along the lines of what most
do as it's a very flexible setup.

Jim.



-----Original Message-----
From: AccessD 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