I have an app (in VB) I'm working on and need to be able to allow the
user to click a button update an existing data source to a new location
(i.e. the current location is C:\MyFolder\MyDatabase.mdb and the new
location is C:\YourFolder\YourDatabase.mdb). The user should be able to
select the new *.mdb file and then the data source automatically updated
to a specific table within the Access database (i.e. tblScheduler). The
current data source is named _MC2KtoOL and has two Data Sets
(tblScheduler and tblSections). Only tblScheduler needs to be updated
dependent on the location of the back end. Thanks for any help!