ACC2000: Append Query Results in Duplicate AutoNumbers (209710)
The information in this article applies to:
This article was previously published under Q209710 SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills.
A table to which you append data by using an append query now has duplicated numbers in a field defined as an AutoNumber data type in
Microsoft Access. The expected result is appended data with incremented numbers in the AutoNumber field.
CAUSE
Your append query is explicitly referencing the field with the AutoNumber data type. You are, in essence, overriding the automatic AutoNumber that you specified in your table design. This may result in duplicate numbers.
RESOLUTION
When creating the append query, do not include a field with an AutoNumber data type in the Append To row of the QBE grid. By omitting this field in your append query, Access will automatically generate
incremental numbers in the table's AutoNumber field.
Modification Type: | Major | Last Reviewed: | 6/24/2004 |
---|
Keywords: | kbprb kbusage KB209710 |
---|
|