title: SQL-Server Backend, MS Access Frontend: Connection
body: <p>Connecting from MS Access to SQL Server via ODBC (not necessarily).
  I would like to bind my Access forms to SQL Server data. It would be great being able to dynamically filter recordsets on the server (as with pass through queries) but I would like to avoid the forms being read-only. I am very grateful for any suggestions. Thanks in advance. I have found similar questions here but not the answer that I am looking for.<br />
  <br />
  I worked with following articles:<br />
  Access DB with SQL Server Back End - Stack Overflow<br />
  Import or link to SQL Server data - Access - Office<br />
  Microsoft is Aligning with ODBC for Native Relational Data Access - FAQ<br />
  Microsoft is Aligning with ODBC for Native Relational Data Access - Microsoft SQLNCli team blog - Site Home - MSDN Blogs<br />
  Optimizing Microsoft Office Access Applications Linked to SQL Server<br />
  performance - Best Practice SQL Server_Access connections - Stack Overflow<br />
  sql server - How to make a passthrough _ passthru query editable_ - Stack Overflow<br />
  sql server - SQL and MS access- filtering of the data on the form - Stack Overflow<br />
  Using Access to build a front end for SQL Server - TechRepublic<br />
  Wiley.Microsoft.SQL.Server.2008.Bible.Aug.2009_Excerpt_Access<br />
  Access as the front end and sql server as the backend - Stack Overflow<br />
  <br />
  I could not find the answer, but I might have overlooked it. Well I must have.</p>