Error entering data in a form

[Brenda from Michigan]

User has Access 2000. User created this database herself some time ago.
This is an intermittent problem for the past couple of weeks. Database is
used by multiple people all the time, so people are in and out of it daily.
This error only happens with one specific form for data entry.

User enters data, then when closing out the error msg pops up. Error msg:
MS Access: MS Access was unable to append all the data to the table. The
contents of fields in 2 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 wnt to proceed anyway? Yes No Help. User clicks on Yes button and it
closes out.

Any idea what might be the problem? Client designed this database so I
would think she knows what data and format goes into each field. Thanks!

 

[Klatuu]

That means another user created and saved a record with values in the primary
key or another field that part of a index that requires a unique value before
she tried to save hers.
It can be happenstance or it can be there are field values being created
when a new record is created based on values in the table that aren't working
as they should.

For example, a common technique is to use a self generated autonumbering
routine. The technique is to grab the highest number in a field using the
DMax function and adding 1 to it. But if a second user starts a new record
before the first user saved the number, the second user to try to save their
record will get an error like this.
Not saying that is exactly it, but that is the sort of thing that causes
this type of error.