This connection string connects (should) to an Access database and its obvious here that it wont connect because VB.NET does not know where the underlying database resides. What if the application is ported somewhere else like a different folder, would the application still be able to connect to the database. Its obvious i would need a data source to specify where the underlying database is but what should i do to have the connection string dynamic in a such a way i can port the application without the need of the data source?
Dim ConnectionString _
As String = "Provider=Microsoft.Jet.OLEDB.4.0;Integrated " & _
"Security=SSPI;Persist Security Info=False;Initial " & _
"Catalog=Students;Packet Size=4096;Workstation ID=Admin;" & _
"Use Encryption for Data=False"