How to Change Connection String at Run Time
One of the challenging parts in VB.NET is to change the connection string of your database location when you run your application.
This tutorial will help you solve this problem. This will apply only to SQL Server but it can be also modified easily to work with MS Access and other DBMS.
In my case I initialize this on the Form Load event on my Login form.