Article ID: 225993 - View products that this article applies to.
This article was previously published under Q225993
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
This article applies only to a Microsoft Access database (.mdb).
When you examine an upsized table that should contain records, you find it contains no data, even though no errors were reported in the Upsizing Report.
A field in your table contains a null value for more than one record and has the following attributes:
If a field in your table is indexed using the No Duplicates option, do not add more than one record that contains a null value for the column in question.
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Steps to Reproduce Behavior
For more information about upsizing databases, click Microsoft Access Help on the Help menu, type upsize your Microsoft Access database in the Office Assistant or the Answer Wizard, and then click Search to view the topic.