title: Migration issue from MS-Access 2003 to MS-Access 2010
body: <p>I work for a company where we likely going to update from Access97/2003 to Access2010.</p>
  
  <p>After playing around with a prototype, I have found an issue when using Access 2010 with databases created in Access 2003.</p>
  
  <p>Under some conditions, existing queries/SQL's in Access 2003 will become unusable in Access 2010. Here a small example:</p>
  
  <p>Tablename: Parameters Field names: Number, Value </p>
  
  <p>A query created with Access 2003 query designer:</p>
  
  <p><code>SELECT Parameters.Value
  FROM [Parameters]
  WHERE (((Parameters.Number)=100));</code></p>
  
  <p>this works fine with Access 2003. 
  In Access 2010 a error is raised: Syntax error in PARAMETER clause</p>
  
  <p>A workaround for the error is to change the view in Access 2003. Here we get rid of the brackets:</p>
  
  <pre><code>SELECT Parameters.Value FROM [Parameters] WHERE Parameters.Number=100;
  </code></pre>
  
  <p>This will work in Access 2010 but the query remains unchangeable in the designer, because the query designer creates the syntax shown above.</p>
  
  <p>The reason for this error is in fact the use of the reserved word 'Number', which shoudn't be used when you start to build a table or query, but for a migration with hundreds of existing databases, it is very likely or at least a risk to change the Access version without a complete test.</p>
  
  <p>My idea is to write a small program which opens all the existing views and the tables to check if they work fine.</p>
  
  <p>Anyway, dose anybody have a better solution for this, or is there a tool to check MS-Access 2003 databases to be compatible with Access 2010?</p>
  
  <p>Many thanks in advance</p>
  
  <p>Jörg</p>