title: SQL Server Reporting Services Access Database
body: <p>I have successfully set up Reporting Services on SQL server 2008 and what I need it to do is create reports from an Access 2007 database stored on another machine. I have added a connection at <a href="http://myServer/reports/" rel="nofollow">http://myServer/reports/</a> like so:</p>
  
  <pre><code>Type: OLE DB
  
  Provider=Microsoft.ACE.OLEDB.12.0; Data source=\\otherServer\shareDirectory\testDatabase.accdb;
  </code></pre>
  
  <p>However, because the connection type is not one of Microsoft SQL Server, Oracle or MS Server Analysis Services, I cannot generate a model! This means that I cannot use report builder as it tells me there are no valid models on the server.</p>
  
  <p>The reason I can't transfer it to SQL Server or anything is because it's almost 1GB!</p>
  
  <p>Am I doing it all wrong? I'm totally stumped.</p>