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

Gustav Brock gustav at cactus.dk
Tue Feb 15 15:17:16 CST 2022


Hi Ryan

Never.
It is only needed if the host or a table schema is changed.

/gustav

Fra: Ryan W<mailto:wrwehler at gmail.com>
Sendt: 15. februar 2022 20:31
Til: Access Developers discussion and problem solving<mailto:accessd at databaseadvisors.com>
Emne: [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-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