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

Rocky Smolin rockysmolin2 at gmail.com
Tue Feb 15 20:40:14 CST 2022


BTW - the table relinker I used, which has accumulated a few modifications
along the years, I originally cribbed from the ADH 2000.

r

On Tue, Feb 15, 2022 at 1:24 PM Bill Benson <bensonforums at gmail.com> wrote:

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


More information about the AccessD mailing list