Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2002: Tables Not Upsized When Query or Table Name Contains Apostrophe
Article ID: 294398 - View products that this article applies to.
This article was previously published under Q294398
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2000 version of this article, see 216218
If you use the Upsizing Wizard to upsize the tables in a Microsoft Access database in which any table or query name contains an apostrophe ('), none of the tables are upsized.
Change the name of the table or the query so that it does not contain an apostrophe, and then repeat the upsizing process.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce the Behavior
For more information about the upsizing wizard, click Microsoft Access Help on the Help menu, type upsizing in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.