The information in this article applies to:
SYMPTOMS
Moderate: Requires basic macro, coding, and interoperability skills.
CAUSEYour append query is explicitly referencing the field with the AutoNumber or Counter data type. You are, in essence, overriding the automatic AutoNumber or Counter function that you specified in your table design. This may result in duplicate numbers. RESOLUTIONDo not include a field with an AutoNumber or Counter data type in the Append To row of the QBE grid in your append query. By omitting this field in your append query, Microsoft Access will automatically generate incremental numbers in the appended table's AutoNumber or Counter field. STATUSThis behavior is by design. MORE INFORMATION
You will receive duplicates only if there is no Primary Key or Index (No)
defined on the AutoNumber or Counter field in the table to which you are
appending. By definition, primary keys are unique.
Keywords : kbusage QryMktbl |
Last Reviewed: March 13, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |