Append Query not work

[Guest]

Dear All,

I tried to use append query to upload some info from one dummy table (called
"employeeupload") to table (called Table "Employee".)
This Table "Employee" has "subdatasheet ", I removed that sub data sheet
(Format-->Subdatasheet-->Removed) .

When I run that append query, I got an error message as follows:

"MS Access can't append all the records in the append query.

MS Access set 0(null) due to a type conversion failure, and it did not add
.... records to the table due to key violations, o records due to lock
violations, and 0 records due to validation rules"

Appreciate if any one may help me on this ?

Many thanks for your help ,

Best Regards

PA

 

[Guest]

It's very hard to answer your question without seeing the table structure and
the data you are appending.
Few points to check

1. Does the data you are appending doesn't create duplicates in the table
you are appending to? Check the table Key and the data can they make a
duplicate error

2. Check the fields in the table you are appending to, if any of them
indicate "Index, No Duplicates"

3. Check the properties of the fields in the table, does any of them has
"AllowZeroLength Property" set to No

Few points to check, but the most important is to check if you are trying to
insert duplicates.

 

[Guest]

Hi Ofer,

Thanks for your quick response

I did check to the database (which created by some one else), and you are
correct with your guidance \ indication number 2. There is field that
contain"Index,No Duplicates".That is the reason that I could not append to
that table.

Again many thanks for your help

Best Regards

PA