Do you have complex queries (Upsizing Problem)?
  v2.0 Posted at 20/10/2010 7:56 PM by System Account
The Upsizing Tools do not try to upsize every type of Microsoft Access query that you may have in your Access (Jet) database. The following varieties of queries will not upsize:
  • Crosstab queries
  • Action queries (append, delete, make-table, update) that take parameters
  • Action queries that contain nested queries
  • SQL pass-through queries
  • SQL Data Definition Language (DDL) queries
  • Union queries
  • Queries that reference values on a form


You must manually re-create queries that the Upsizing Tools do not migrate.

Related rules

    Do you feel this rule needs an update?

    If you want to be notified when this rule is updated, please enter your email address: