title: C# - OleDbConnection.Open() causing a crash
body: <p>Fairly new to C#, anyway, I have this Initialise method that I've written, it basically creates a connection to a MS2007 Access Database, fills a DataSet with the 4 DataTables that are the result of some queries.</p>
  
  <pre><code>    public frmDBCompareForm()
      {
          ///
          /// Required for Windows Form Design support
          ///
          InitializeComponent();
          frmDBCompareForm_Initialize();
  
          //
          // TODO: Add any constructor code
          //
          if (_InstancePtr == null) _InstancePtr = this;
      }
  </code></pre>
  
  <p>And the start of the Initialise Method, including one of the DataTables being filled:</p>
  
  <pre><code>private void frmDBCompareForm_Initialize()
      {
          // Fill DataSet with 3 DataTables, these tables will be 
          // made up of the from sQuery.
          try
          {
              // Create a new DataSet
              DataSet dsSite1 = new DataSet();
              // Set up the connection strings to HCAlias.accdb
              OleDbConnection con = new OleDbConnection();
              con.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\HCAlias.accdb;Persist Security Info=False;";
              con.Open();
              //
              // Table 1 - dtSite1Name [cmbSite1]
              //
              dtSite1Name = new DataTable();
              string sQuery = "SELECT SourceName From Sites";
              OleDbCommand cmdSite1Name = new OleDbCommand(sQuery, con);
              OleDbDataAdapter myDASite1Name = new OleDbDataAdapter(cmdSite1Name);
              myDASite1Name.Fill(dsSite1, "dtSite1Name");
              cmbSite1.DataSource = dtSite1Name;
              cmbSite2.DataSource = dtSite1Name;
  </code></pre>
  
  <p>Could anyone point me in the right direction for going about this the way I have? Any tips or advice to get that connection issue fixed? I've been Googling like a boss, but can't seem to find the exact issue that I'm having.</p>