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

[Bill Benson]

That is what I suspected, thanks for confirming.

Also want to point out the one major app I used to distribute to many users
did occasionally fail to relink all tables. That makes it doubly ridiculous
to relink everything on startup if nothing is likely to have changed on the
BE.

On Tue, Feb 15, 2022 at 4:44 PM Gustav Brock via AccessD <
accessd at databaseadvisors.com> wrote:

> 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?
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>