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

[Gustav Brock]

Hi Bill

If the (remote) host is the same, yes. Why not? There is nothing to change or update. Those applications don’t even have a relinker.
If a table scheme is modified, the client is passed new versions of the applications, and the users’ launch scripts will update automatically at the next launch.

/gustav

Fra: Bill Benson<mailto:bensonforums at gmail.com>
Sendt: 15. februar 2022 22:24
Til: Access Developers discussion and problem solving<mailto:accessd at databaseadvisors.com>
Cc: Gustav Brock<mailto:gustav at cactus.dk>
Emne: Re: [AccessD] Question: How often do you run your remote table relinking code?


Not sure about something:

When sending a default or new FE to a new user, would you ship the FE with tables already linked or perform a link on first use of that FE?

On Tue, Feb 15, 2022 at 4:17 PM Gustav Brock via AccessD <accessd at databaseadvisors.com<mailto:accessd at databaseadvisors.com>> wrote:
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<mailto:wrwehler at gmail.com>>
Sendt: 15. februar 2022 20:31
Til: Access Developers discussion and problem solving<mailto:accessd at databaseadvisors.com<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?