title: Connecting to an Access database with ASP.NET
body: <p>I want to be able to use a database Foo.accdb in my ASP.NET project.
   What is the best way to connect to it? I want to make sure the project can be ported to another computer and still work, so should I just put the database file inside the project folder (the same folder where Default.aspx is located)?</p>
  
  <p>Do I need to import the database into Visual Studio somehow? </p>
  
  <p>I just want to be able to use the OleDb family of classes to manipulate the data. If this is all you have to do, is the path inside Web.config relative to Web.config? </p>
  
  <p>So my connection string would be like:</p>
  
  <p><code>Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Foo.accdb;User Id=admin;Password=;</code></p>