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

[Ryan W]

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
>