easiest way to connect to a changing data source use oledb-msda-sql insteat of using an (direct) odbc connection.
I noticed that when you use odbc to access-mdb, changing the location of the mdb in your odbc-setup doesnt't result into connecting to this new mdb !!!!!
the oledb-msda-sql driver is doing this correct.

at your service,

Don