title: Connecting a Multi User Access Front End to SQL Server Back End
body: <p>Thank you for your help as always!</p>
  
  <p>I have built an Access database that we intend to distribute to ~100 end users.  I am currently running a pilot program for 5 users.  I have migrated the tables to SQL 2014 Server but currently the back end of the pilot program is in a shared network folder (location unknown to them).  I distributed the Access front end (accde file type) by saving the file on that shared Network and instructing the end users to save a copy to their desktop.  The pilot is working fine, if not a little slow.</p>
  
  <p>The issue that I am having is this:</p>
  
  <p>I am able to set up an ODBC Connection on my machine and am able to connect to the SQL Server backend through that  connection.  However, I am not sure how to get my end users Access to the tables on the server.  Do I need to create a user name for each user on the server and give them read and write access?  Do I also need to create an ODBC connection on each machine that we plan to install the Front End on?  I would prefer to not have to create an ODBC connection on each machine, is it possible to work around this?  Thank you!</p>
  
  <p>Access Version: 2013
  SQL: 2014
  Working on SSMS 2014</p>
  
  <p>-Charlie</p>