[AccessD] Question: How often do you run your remote table relinking code?
Ryan W
wrwehler at gmail.com
Tue Feb 15 13:31:07 CST 2022
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-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?
More information about the AccessD
mailing list