I have encountered this problem.
For example:
table 1= table 2 both use autonumber.
Table 1 has 3 records (autonumber 1,2,3)
Table two has six records.(autonumber 1,2,3,4,5,6)
If you add Table 2 to table one you will still only end up with six records
but will get the error message you talked about. The added table will have
records 1 2 3 from table 1 and 4 5 6 from table two.
If you add table 1 to table two you will end up with the same six records as
table 2
"WindAndWaves" <ac****@ngaru.com> wrote in message
news:Ab*********************@news.xtra.co.nz...
<ky***@mvlhawaii.com> wrote in message
news:11*********************@o13g2000cwo.googlegro ups.com... When I try to append one table to another with the exact same field
names I get an error...
Microsoft Access was unable to append all the data to the table.
The contents of fields in 0 record(s) were deleted, and 0 record(s)
were lost due to key violations.
*If data was deleted, the data you pasted or imported doesn't match the
field data types or the FieldSize property in the destination table.
*If records were lost, either the records you pasted contain primary
key values that already exist in the destination table, or they violate
referential integrity rules for a relationship defined between tables.
Do you want to proceed anyway?
What is causing this message? When I append, I am only missing 3 out
of 342 rows... Where should I check to fix this issue?
The very first thing I would like at is the table that you are pasting
into, namely:
-indexes: does the paste create any double entries where each value should
be unique
- zero length entries - are fields required
- primary keys
I am almost 100% sure that there is a violation taking place with one of
the rules above.
You can fix this by
a. changing the rules, indexes, etc.. of the table that is pasted into
b. changing the data that you are pasting into the table (e.g. if you make
it a "totals query" then only unique combinations will be
added.
HTH
let me know how you get on.
- Nicolaas