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

[Bill Benson]

That is what I would do, I would not just relink all tables on open unless
it could be demonstrated that the select queries take longer than relinking.

On Tue, Feb 15, 2022 at 2:51 PM Ryan W <wrwehler at gmail.com> wrote:

> Well in the article, ben uses a select statement that would only work on
> the back end.  I just adapted it from a MySQL statement to a MSSQL
> statement.  SELECT USER_NAME()  instead of whatever he had.
>
> As long as that temporary querydef succeeds, the idea is any linked tables
> with the trifecta of matching information (database, server, driver) match
> the cached credential.... you're golden.
>
>
>
> On Tue, Feb 15, 2022 at 1:44 PM Bill Benson <bensonforums at gmail.com>
> wrote:
>
> > No answer to this. However *if* someone were doing this just to make sure
> > the tables are validly connected:
> >
> > Would using VBA to test the table statuses by running a series of well
> > chosen select statements be faster than automatically re-linking all BE
> > tables?
> >
> > On Tue, Feb 15, 2022 at 2:31 PM 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
> > >
> > --
> > 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
>