title: Sharepoint: Connect to Access DB (.accdb) in document library
body: <p>I have a site where a database is placed inside a document library. I need to extract data from this database and show in a webpart.</p>
  
  <p>Is there a Sharepoint-specific way of doing this, or I simply connect normally with a regular connection string and just point it at the filename in the document library, eg: <a href="http://spsite/doclib/database.accdb" rel="nofollow">http://spsite/doclib/database.accdb</a>?</p>
  
  <p>I do not need to pull this data very often, so if there's overhead from "fetching" the database from the document library and into memory that can be overlooked. It just seems as though SP should have a built-in feature to access data.</p>
  
  <p>I tried searching for how to get Sharepoint 2007 to show data from an access database, but to no avail.</p>
  
  <p>(Note: I have no problem with the connection string, SQL, showing the data, etc. - the problem is how to connect to the database so I can execute the queries)</p>