Updating the connection string

[robert d via AccessMonster.com]

I have a separate logon form that I use to open my workgroup secured app.
I've recently included the ability to select the folder location of the
backend file on this logon app. I'm passing this folder location to the
front-end app using the Command function.

So far so good.

The question is: What method should I use for updating the connection strings
for the backend tables if the backend folder location is different than
what's contained in the front-end app existing connections. Should I go
directly into the MSysObjects table and modify the Database field or should I
somehow use the tabledefs.

 

[John Nurick]

TableDefs: see e.g. http://www.mvps.org/access/tables/tbl0009.htm.