This is just one of the problems with these home-made type primary keys.
SSN numbers need to repeat at some point; why do you think yours (with one
less character) won't. This is just another example of why autonumber
integers work as one of the best primary keys.
If the error msg is "x records not added to key violations" then you have
potential duplicates, and they cannot be added, as the key values must be
unique. You can run a "find unmatched records" query to see which ones are
dupes, or remove the key property, append the records, then search for
duplicates created.
-Ed
<st**********@gmail.com> wrote in message
news:11*********************@l41g2000cwc.googlegro ups.com...
To all:
Hi! I am trying to use an append queries on a table where the key
field is numeric, formatted as 00-00-000. The query collects the
information corectly, and there are no records duplicated, but I get a
key violation each time I try to run the query. Any ideas?
More details: The query collects, concatenates, and turns the key field
to be appended into a value. I have tried formatting the query's field
as 00-00-000, as well as with no formatting.
Thanks,
Sean