title: Access (OleDb) Parameter Prompt Order
body: <p>I know when using Access (or OleDb in general) it is important to provide the parameters in the right order, even if you name them, as they are always picked up by their order, regardless of name.</p>
  
  <p>However in this query:</p>
  
  <p><code>
      SELECT Comments.ID, Users.Nom, CommentsHelpfulness.Helpful
      FROM (Comments INNER JOIN Users
      ON Comments.UserID = Users.ID)
      LEFT JOIN CommentsHelpfulness
      ON (CommentsHelpfulness.CommentID = Comments.ID
      AND (CommentsHelpfulness.UserID = [enter userid]))
      WHERE (Comments.GameID = [enter gameid])
  </code></p>
  
  <p>why does Access prompt me for the gameid, before it prompts me for the userid? It turns out using this in my asp.net website, I also have to add the gameid first.</p>
  
  <p>How is the order actually determined, in which I have to add the parameters? I thought it's just left to right. (I don't want to know how to change the order, I'm really just interested in how it is determined)</p>