Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
ACC2000: Tables Not Upsized When Query or Table Name Contains Apostrophe
Article ID: 216218 - View products that this article applies to.
This article was previously published under Q216218
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2002 version of this article, see 294398
If you use the Upsizing Wizard to upsize 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 query so that it does not have an apostrophe and repeat the upsizing process.
Steps to Reproduce 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.