ACC2: Failed Append Query Still Increments Table Counter by 1Last reviewed: May 14, 1997Article ID: Q154010 |
The information in this article applies to:
SYMPTOMSNovice: Requires knowledge of the user interface on single-user computers. When you run an append query that appends zero rows, the counter value in the table is incremented by one. NOTE: This behavior also occurs in a make-table query that copies zero rows to the new table.
RESOLUTIONAfter you run an append query or make-table query that returns zero rows, you can reset the counter value by compacting the database. For more information about this topic, search on the word "Counter," and select "Changing the Starting Value of a Counter Field (Common Questions), using the Microsoft Access 2.0 Help Index.
STATUSMicrosoft has confirmed this to be a problem in Microsoft Access 2.0. This problem no longer occurs in Microsoft Access version 7.0.
MORE INFORMATIONCAUTION: Following the steps in this example will modify the sample database NWIND.MDB. You may want to back up the NWIND.MDB file, or perform these steps on a copy of the NWIND database.
Steps to Reproduce Problem
|
Additional query words: Make Table Increments
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |