One of the problems that a beginner encounter when there is a project uploaded here, is they do not know on how to change the connection string that points to the correct database location. This is true with MS Access and even with SQL Server. Some programmers don’t add a code that will automatically change the location of the database just in case it will be ported in other machine.
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.
Microsoft Access is a DBMS that is known to almost all of us. Most of the computer professionals must have used this DBMS at least once in their lifetime. With the help of Microsoft Access we can easily create new relational databases, insert, and update and delete data. Microsoft Access has gained more popularity with its ability to relate one or more tables in the database.