title: How do I retain database connectivity, with my project, when the source file path changes?
body: <p>I am using a <strong>Microsoft Access Database</strong> in my project; saved to the bin folder. What can I do, to ensure connectivity to that database, when the file path changes?</p>
  
  <blockquote>
    <p>Imports System.Data.OleDb
    Public Class Form3</p>
    
    <p>Dim con As New OleDb.OleDbConnection</p>
    
    <p>Dim da As OleDbDataAdapter</p>
    
    <p>Dim ds As New DataSet</p>
    
    <p>Dim str1 As String</p>
  </blockquote>
  
  <pre><code>    con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\Users\AARVIII\Documents\DATABASE\MP1.accdb"
  </code></pre>