title: Access 2007 querying the SQL DB like crazy
body: <p>I am having to optimize an Access app, and I noticed that it's querying the database for reasons I don't understand. It's an existing app, so I created a view, which populates a split form -- recordset at the bottom, form at the top. </p>
  
  <p>I am unable to figure out why access is doing stuff like below. It is preparing this query, and runs it for EVERY RECORD in the table, resulting in many tens of thousands of queries. </p>
  
  <p>This is wild, I am new to Access, and I am thinking it has to do with specifying the recordset as a 'dynaset'. The form has to be updateable. </p>
  
  <p>Also, how do I get dropdown filters enabled to filter the recordset at the bottom. Do I have to have indecies defined for each column in the underlying view? Please advise -- I am pretty lost over here.</p>
  
  <pre><code>exec sp_prepexec @p1 output,
  N'@P1 nvarchar(255)',
  N'SELECT "Provider_ID"
  ,"Provider_CAT"
  ,"Risk Assoc"
  ,"Contracted"
  
  -- snip lots of fields 
  
  ,"Updated Project"
  ,"Provider Status" 
  FROM "dbo"."MRA_Providers_To_Schedule"  
  WHERE "Provider_ID" = @P1',N'00001'
  </code></pre>