Rules to Better Access Databases

Microsoft Gold Partner Logo
Search Go Search
SSW Rules/Reporting Solutions/Rules to Better Access Databases/Do you have complex queries (Upsizing Problem)?
Rule #16
Do you have complex queries (Upsizing Problem)?
  v2.0 Posted at 20/10/2010 7:56 PM by system
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.

 

Tell a Friend
Loading
Do you like this rule?
Loading
Do you follow this rule?
Loading

« Back #15 Do you have fields with mul ...
#17 Do you avoid parameter quer ... Next »

Related Links

......