title: How to use ADOX to connect to existing Access database
body: <p>From a quick google i found out how to use ADOX to create a new database and add some tabels and rows to it. Here is an example:</p>
  
  <pre><code>using ADOX;
  ...
  ADOX.Catalog cat = new ADOX.Catalog();
  cat.Create("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=mydb.accdb;");
  Table mainTable = new Table();
  mainTable.Name = "Test Table";
  mainTable.Columns.Append("Column_1");
  cat.Tables.Append(mainTable);
  </code></pre>
  
  <p>This creates a new database and works with that newly created database but <strong>If I had an existing database, how would I get <code>ADOX.Catalog cat;</code> to connect to the existing database?</strong></p>