I have a new application and I'd like to be able to chnage the location of the access database it connects to at runtime. At the moment the installer I have created installs the database file to the %appdata%\company\app folder, which is different to the location of the debug DB file (next to the application itselft).
I want to have a line of code that changes the connection string to point at the correct location but I cannot seem to find a way to change the connectionstring property. Every method I try seems to say Read Only and doing a search seems to throw up more ASP.NET / WEb / VB code than what I need!
I really hope someone can help as, eventually, I plan on giving the user the chance to change the location of the database via my settings dialog and then store that information for each run - so I would need to load that then change the connectionstring on each run.