Do you have complex queries (Upsizing Problem)?

Updated by Brady Stroud [SSW] 1 year ago. See history

123
<introEmbed body={<> 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.

Acknowledgements

Adam Cogan
Related rules

Need help?

SSW Consulting has over 30 years of experience developing awesome software solutions.

We open source.Loving SSW Rules? Star us on GitHub. Star