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

[Rocky Smolin]

I had table relinking code in a module which I imported into every FE/BE
app. The relinker is called only when the program opens and checks for
valid table links. So unless they move the back end, or I send a front end
update (which of course opens the find file dialog box so they can point to
it and relink the tables) the relinker code is never run. But I'm using
mdbs and accdbs for back ends.  Life is simple.

r

On Tue, Feb 15, 2022 at 11:31 AM Ryan W <wrwehler at gmail.com> wrote:

> 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
>