Rules

Secret ingredients to quality software

Edit
Info

Do you have complex queries (Upsizing Problem)?

Last updated by System Account on 20 Oct 2010 08:56 am (almost 11 years ago) See History

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.

Adam CoganAdam Cogan

We open source. This page is on GitHub