Microsoft KB Archive/225993

= ACC2000: Data Not Upsized in Table with Index =

Article ID: 225993

Article Last Modified on 1/26/2005

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q225993



Moderate: Requires basic macro, coding, and interoperability skills.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
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.



CAUSE
A field in your table contains a null value for more than one record and has the following attributes:
 * The Indexed property is set to Yes (No Duplicates).
 * The Required property is set to No.



RESOLUTION
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.



STATUS
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
 Start Microsoft Access, and in the opening Microsoft Access dialog box, click Blank Access Database. Click OK. Name the database NullTest, and click Create. In the Database window, click Tables. Click New, click Design View, and then click OK. Create the following table: </li> Save the table as MyTable.</li> Open the MyTable table in Datasheet view.</li> Add the following three records to the empty table:

NOTE: Values in the MyPK field are automatically populated. Do not try to manually add this data.</li> Select the value "y" in the second record of the table and delete it.

NOTE: To delete the value, select to highlight the character and use the DELETE key to remove it. Do not press SPACEBAR.</li> Delete the value "x" from the first record.</li> Close the Table.</li> On the Tools menu, point to Database Utilities, and then click Upsizing Wizard.</li> Select the Create new database option when prompted, and click Next.</li> On the next screen, provide a Server Name to connect to and the Login Id and Password of an account that has permissions on the server. Use the database name suggested by the wizard.</li> Click Next, and then choose to export the MyTable table to SQL Server. Click Next twice.</li> In the What application changes do you want to make group box, select Create a new Access client/server application.</li> Click Finish, and allow the Upsizing Wizard to complete its work.</li> View the Upsizing Report and note that no errors appear. After you have examined the report, close it.

After a moment, the new Access project that was created by the wizard will automatically open.</li> In the Database window, click Tables.</li> Double-click the MyTable table and note that it contains no data.</li></ol>

<div class="references_section">