I know how to use the Add New Datasource wizard to add a connection to an Access database to my project. The wizard puts the connection string in My.Settings.FooConnectionString.

Since my users will inevitably move or rename the Access file, I'd like to be able to pop up a file dialog box, collect the correct pathname of the Access file and write it into My.Settings.FooConnectionString.

Does this make sense? What do I need to do to (re-)establish the connection to the database after I've changed the connection string?