MS access can't append all the records in the append query

[japi_s]

hi Guys,
I have been looking at different post and checking Microsoft help files as well, but still can't seem to fix this problem.

I am having 2 tables. The first table is connected to a form for viewing and entering data, and in the second table i am just copying 3-4 fields from the first table.

I am trying to use the insert statement to insert records in the second table, and everytime i click on the "Add" button to add the records i get the following error "MS access can't append all the records in the append query ... blah blah blah"

However if i close the form and reopen it, and goto the record (as it is saved in the first database) and now click on the add button to add the fields to the second table/database, it works.

What am i doing wrong???

Any inputs will be greatly appreciated.

 

[Moniker]

You left out the most important part of the error message. You blah blah blahed over the reasons it's telling you it can't append. Are there key violations? Is it a data type mismatch? What is the message?

 

[japi_s]

You left out the most important part of the error message. You blah blah blahed over the reasons it's telling you it can't append. Are there key violations? Is it a data type mismatch? What is the message?

The blah blah is.... (lol)
Microsoft Access can't append all the records in the append query.
Aicrosoft Access set 0 fields to Null due to type conversion failuer, and it didn't add 1 records to the table due to key violation, 0 records due to lock violation, and 0 records due to validation rule violation.
Do you want to run the query anyway?

hope this helps

 

[The_Doc_Man]

The message is telling you that your table demands uniqueness in some field that would no longer be unique if the import happened as you requested.

You have a duplicate value in a no-duplicates field.