Is there a way to override the connection string of a secondary data source? Here is my situation: I have a few different secondary data sources in my form. Each time I roll from development to production I have to change each secondary data source to look at the other database. Of course once you switch database, you have to re-link your tables for the datasource. This can be painful if you have alot of joins. Is there a way to control which database all secondary datasources use with one setting? Thanks in advance for any help here. Ideally I'd like to be able to override the connection of these data sources on my Form Load event.
Bryan