Append Query Question

  • Thread starter Thread starter aa
  • Start date Start date
A

aa

Thank you for your help and answer:
I’m using Append Query to make back up copy of my data in the table to
another table the data in the source table Maybe change so I run the append
query again this error message appear:
Microsoft Access can’t append all the records in the append query.
Microsoft Access set 0 fields(s) to Null due to a type conversion failure,
and it didn’t add 33 record(s) to the table due to key violations, 0
record(s) due to lock violations, and 0 record(s) due to validation rule
violations.
Do you want to run the action query anyway?
To ignore the error(s) an run the query, click yes
For an explanation of the causes of the violations click help
Notes:
- The fields of the table and append query is same for example:
ID Autonumber
Player Name Text
PhoneN text
- I’m using Forms to run query
- You see that ID Is Unique Identifier and not change the player name or
Phone will change..
- If I remove The ID Autonumber Field the data will be duplicated in the
backup table…
What I want:
I want to make an easy way for the user to backup tables without using any
application (back up application) and using only access and no error to
confuse the user .
Thank you for reading this message and thanks for the help and suggestion
 
I am a starter and I had similar issues a week or so ago.
I discovered by trial and error that I get this message
when any of the indexes in the table being appended gets a
duplicate value.

Thus, you need to reword your query to eliminate the
possibility of creating duplicates in the appended table.
It worked for me, but I cannot guarantee that it will work
for you.

The complexity of the query is proportion to the number
and complexity of indexes that you have on the table that
you are backing up.
 
AA- I have been working on the exact same thing word for
word for two weeks - If you find the answer please post
and I will do the same.
 
Back
Top