title: ODBC--call failed (Attempting to open a table in MS Access)
body: <p>First of all, I know there are a few other questions with a similar issue but I really would appreciate a clear and working answer.  </p>
  
  <p>My colleagues and I have tried opening the database from Access (front-end) and this error only came up when either of us tried opening one table or a query. 
  I checked my ODBC and I have the Native Client for SQL 11.--- etc.</p>
  
  <p>They were able to access the database after a couple attempts.</p>
  
  <p>Notes:
  The backend is MS SQL Server 2008 R2
  The frontend is MS Access
  Users run Windows 10 on their local machines and access the database frontend through MS Access.
  Only two users are able to access the backend from their local machines, myself included. </p>
  
  <p>Can someone share any notes that are relevant to this issue? Kind answers please because I have received some really sarcastic answers and I am new to database management in a large organisation.
  <a href="https://i.stack.imgur.com/y211C.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/y211C.jpg" alt="ODBC Driver"></a></p>
  
  <p>Any assistance will be greatly appreciated.</p>
  
  <p>Update:
  My superior told me and I noticed as well that the semi-colon is dropped when passing a query. I will get more information on this tomorrow but I have a screenshot of what I am trying to say:</p>
  
  <p>The yellow mark indicates where the semi-colon supposed to be
  <a href="https://i.stack.imgur.com/9qcxV.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9qcxV.jpg" alt="Semi-colon missing?"></a></p>